Execute oracle procedures from VB, TOAD...

From: Louis P. <louis.p.dauphinais_at_dr.cgocable.ca>
Date: Fri, 15 Mar 2002 21:32:23 GMT
Message-ID: <HLtk8.502$dh.45191_at_bin2.nnrp.aus1.giganews.com>


i have an Oracle procedure containing some OUT parameters like that:

Procedure ISSUE (

ERR_NO       OUT    NUMBER,
RET_COL     OUT    VARCHAR2,
RET_VAL     OUT    NUMBER,
PART_NO                NUMBER,

...

because of these OUT parameters, the only way i found to call the procedure in TOAD, VB, Access, etc is by doing this:

Begin declare ErrNo NUMBER; RetCol VARCHAR2(50); RetVal NUMBER; Begin ISSUE(ErrNo, RetCol, RetVal, 100000, ...); End;
Commit;
End;

Now, this will run the procedure fine but i cannot retreive the output values. Is there some way i can get those values without having to use SQL*PLUS.

thanks for any help Received on Fri Mar 15 2002 - 22:32:23 CET

Original text of this message