Hi All,

I'd like to be able to return a value from an Oracle Procedure or Function. Either or doesn't matter. This has to be done using SQL passthrough. Here's as far as I've gotten in a simple test.

LOCAL lnFirstNo, lnSecondNo, lnReturnNo
lnFirstNo = 10
lnSecondNo = 15
lnReturnNo = 0

lcSqlStatement = "{ CALL Add_Two_Val(?lnFirstNo, ?lnSecondNo, ?lnReturnNo) }"
lnConHndl = sqlexec(lnSatHandle, lcSqlStatement)

This is the procedure I made.

CREATE OR REPLACE PROCEDURE Add_Two_Val(
   pnFirstNum  IN NUMBER,
   pnSecondNum IN NUMBER,
   pnRetValue IN OUT NUMBER)
IS
BEGIN
  pnRetValue := pnFirstNum + pnSecondNum;
END;
/

What am I missing?

TIA
Mike

VFP6 SP5 Oracle 8i