Database Operational Interfaces Implementation

The tables below show the required parameters to implement a stored procedure in each of the supported databases. Also included are screenshots of basic implementations in MySQL and Microsoft SQL Server.

MySQL:

Parameter	Type	Direction	Nullable	Example
pBarcode	Varchar(50)	In	N	123456
pLocationID	Int	In	N	1
pResponse	Varchar(200)	Out	N	Good, Wrong Door!
pResponseColor	Varchar(10)	Out	N	#00FF00 (Green), #FF0000 (Red)
pPalletStatus	Int	Out	N	0 = Wrong, 1 = Good
pOrderNumber	Varchar(200)	Out	Y	ABC123
pDwellTime	Int	Out	N	10000
pAudibleKey	VarChar(200)	Out	Y	Good
pMetaDataDisplay	VarChar(1000)	Out	Y	<p>CARRIER: FEDEX</p> <h1>PALLET COUNT: 10/25</h1>

Microsoft SQL Server:

Parameter	Type	Direction	Nullable	Example
@Barcode	Varchar(50)	In	N	123456
@LocationID	Int	In	N	1
@Response	Varchar(200)	Out	N	Good, Wrong Door!
@ResponseColor	Varchar(10)	Out	N	#00FF00 (Green), #FF0000 (Red)
@PalletStatus	Int	Out	N	0 = Wrong, 1 = Good
@OrderNumber	Varchar(200)	Out	Y	ABC123
@DwellTime	Int	Out	N	10000
@AudibleKey	VarChar(200)	Out	Y	Good
@MetaDataDisplay	VarChar(1000)	Out	Y	<p>CARRIER: FEDEX</p> <h1>PALLET COUNT: 10/25</h1>

Oracle:

Parameter	Type	Direction	Nullable	Example
pBarcode	Varchar2(50)	In	N	123456
pLocationID	Int	In	N	1
pResponse	Varchar2(200)	Out	N	Good, Wrong Door!
pResponseColor	Varchar2(10)	Out	N	#00FF00 (Green), #FF0000 (Red)
pPalletStatus	Int	Out	N	0 = Wrong, 1 = Good
pOrderNumber	Varchar2(200)	Out	Y	ABC123
pDwellTime	Int	Out	N	10000
pAudibleKey	VarChar(200)	Out	Y	Good
pMetaDataDisplay	VarChar(1000)	Out	Y	<p>CARRIER: FEDEX</p> <h1>PALLET COUNT: 10/25</h1>

See example procedures below.

MySQL:

Microsoft SQL Server:

Oracle: