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