Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Overloading Stored Proc
I have an overloaded stored proc in a packagein Oracle 8.1.6. It
looks something like this:
MyProc (
v1 VARHCAR2 IN
v2 VARHCAR2 IN
a1 VARCHAR2 OUT)
MyProc (
v1 VARHCAR2 IN
v2 VARHCAR2 IN
v3 VARHCAR2 IN
a1 VARCHAR2 OUT
a2 VARCHAR2 OUT
a3 VARCHAR2 OUT)
It compiles fine. And I have a test M$ Active Server Page that can call both versions of this proc without a problem and get the correct results.
A collegue that is attempting to call this proc from Powerbuilder can't seem to figure out how to call it. In fact, he told me he couldn't figure out how to call it from SQL Plus. So I tried to call it from SQL Plus and had wierd errors that led me to believe it was confused with one OUT in the one proc and three OUTs in the other.
Can someone enlighten me on the correct syntax on how to declare the vars and call this from SQL Plus? If I make both have the same # of OUT vars it seems to like that better. I gotta believe it's possible to do what I'm attempting since it's working from an ASP and that I'm just clueless on SQLPlus.
Any help appreciated!
Todd
trhaverstock_at_yahoo.com
Received on Mon Apr 15 2002 - 19:48:28 CDT