Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ODBC and Functions signature
Hi All,
I´m calling pl/SQL functions from ODBC. I have two functions with different signature:
PACKAGE pgtest
BEGIN
function f1(p1 OUT NUMBER) -- Function A
return NUMBER;
function f1(p1 OUT NUMBER, -- Function B
p1 OUT NUMBER,)
return NUMBER;
END:
I want to call Function B via ODBC, I´m using the signature with two
function parameters. (SQLPrepare, SQLBindParameter, SQLExecute)
Calling function B via ODBC ever fails, it just sees Function A and produces an error due to incorrect signature.
When I switch the sequence of the functions in the PL/SQL package, all runs well!
Does anyone know, why ODBC / PL/SQL acts like this?
Thank you in advance
WolframReceived on Fri Apr 26 2002 - 03:59:40 CDT