Help on calling a stored procedure (with JDBC)

From: 4 Integration <4integration_at_gmail.com>
Date: Thu, 26 Apr 2007 21:50:36 +0200
Message-ID: <f0qvqd$3pc$1@independence.tornevall.net>

Hello,

I don not have much knowledge in store procedures and need to help to get started.

I have got a signature of an Oracle stored procedure that I need to call from a java app (JDBC thin driver).

Can I determine if there are optional parameters from the signature? Which data types are used?

---

Declare

l_TransactionType  Inventory_Transaction.Code%type := 'Inv Lock';
l_LockStatus       Inventory_Transaction.Lock_Status%type := 'Locked';
l_LockCode         Inventory_Transaction.Lock_Code%type := 'DMGD';

l_Result		integer;

Begin

	l_Result := LibInvTrans.CreateInvTrans
	(
		l_TransactionType,


		:qty,

		:qty,

		:client_id,

		:sku_id,

		:tag_id,

		null,			/* Batch ID */
		null,			/* Condition ID */
		null,			/* To Location */


		:location_id,

		null,			/* Final Location */
		null,			/* Reference */
		null,			/* Line ID */
		null,
		'INTERFACE',		/* Station ID */
		'INTERFACE',		/* User ID */
		null,			/* Notes */
		null,			/* ElapsedTime */
		'W',			/* Session Type */
		'Y',			/* Summary_Record */


		:site_id,

		null,			/* From Site ID */
		null,			/* To Site ID */


		:container_id,

		:pallet_id,

		null,			/* List ID */
		null,			/* Expiry Date */


		:owner_id,

		:origin_id,

		null,			/* work group */
		null,			/* Consignment */
		null,			/* Manufacture Date */
		null,			/* TaskCategory */
		l_LockStatus,
		null,			/* QC Status */
		null,			/* Supplier ID */
		null,			/* Sampling Type */
		null,			/* User Defined Type 1 */
		null,			/* User Defined Type 2 */
		null,			/* User Defined Type 3 */
		null,			/* User Defined Type 4 */
		null,			/* User Defined Type 5 */
		null,			/* User Defined Type 6 */
		null,			/* User Defined Type 7 */
		null,			/* User Defined Type 8 */
		null,			/* User Defined Chk 1 */
		null,			/* User Defined Chk 2 */
		null,			/* User Defined Chk 3 */
		null,			/* User Defined Chk 4 */
		null,			/* User Defined Date 1 */
		null,			/* User Defined Date 2 */
		null,			/* User Defined Date 3 */
		null,			/* User Defined Date 4 */
		null,			/* User Defined Num 1 */
		null,			/* User Defined Num 2 */
		null,			/* User Defined Num 3 */
		null,			/* User Defined Num 4 */
		null,			/* User Defined Note 1 */
		null,			/* User Defined Note 2 */
		null,			/* Job ID */
		null,			/* Job Unit */
		null,			/* Manning */
		null,			/* Spec Code */
		null,			/* XYZ Estimated Time */
		null,			/* GRN */
		null,			/* Completed Date */


		:config_id,		/* Pack Config */

		null, 			/* CE_Orig_Rotation_ID */
		null,			/* CE Rotation ID */
		null,			/* CE Consignment ID */
		null,			/* CE_Receipt_Type */
		null,			/* CE_Originator */
		null,			/* CE_Originator_Reference */
		null,			/* CE_COO */
		null,			/* CE_CWC */
		null,			/* CE_UCR */
		null,			/* CE_Under_Bond */
		null,			/* CE_Document_DStamp */
		'N',			/* Customs Uploaded */
                 l_LockCode,
                 null,   		/* Print Label */
                 null,   		/* ASN ID */
                 null,   		/* Customer ID */
                 null			/* CE_Duty_Stamp */
         );

End;
/

---

-- 
// 4 Integration

Received on Thu Apr 26 2007 - 14:50:36 CDT