Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help on calling a stored procedure (with JDBC)

Re: Help on calling a stored procedure (with JDBC)

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 26 Apr 2007 15:21:28 -0700
Message-ID: <1177626088.884384.307260@t38g2000prd.googlegroups.com>


On Apr 26, 3:50 pm, 4 Integration <4integrat..._at_gmail.com> wrote:
> 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

Have you tried doing a describe on the procedure? Received on Thu Apr 26 2007 - 17:21:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US