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

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 26 Apr 2007 22:18:02 -0500
Message-ID: <uzm4uuy2f.fsf@rcn.com>

On 26 Apr 2007, johnbhurley_at_sbcglobal.net wrote:

> 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
>> (

[...]

>
> Have you tried doing a describe on the procedure?

And to hpuxrac's point, the package's name is LibInvTrans and the procedure's name is CreateInvTrans.

Another thing to understand. What you posted is the PL/SQL script that the PL/SQL developer used to test his/her code, not the "signature" of the Oracle stored procedure. That would have been in the spec of the package.

-- 
Galen Boyer

Received on Thu Apr 26 2007 - 22:18:02 CDT