Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL function return value problem
Hello,
I created a stored function which returns a number.
When I execute the function as PL/SQL block the returned number is non-zero
value.
But when I tried to call the function from my Visual Basic application using
Oracle Objects for OLE like this:
Dim diff_count as Integer
objDataBase.Parameters.Add "tname", "Mytable", ORAPARM_INPUT objDataBase.Parameters("tname").ServerType = 1 objDataBase.Parameters.Add "diff_count", 3, ORAPARM_OUTPUT objDataBase.Parameters("diff_count").ServerType = 2Set PlSqlStmt = Nothing
In this case MY_FUNCTION returns 0 every time, so diff_count = 0 .
I think something wrong with passing output parameter back from Oracle to vb
application.
Could you give me a hint how to fix the problem?
Thanks,
Gennady
Received on Wed Jul 05 2000 - 00:00:00 CDT