Doh! I lied. With the guts of the SP actually ripped out it returns the correct value. Please ignore. I obviously have a problem with my SP so I'll head over to the Oracle forum and see if anyone can help <g>
>Does anyone know the syntax for returning a value from an Oracle stored procedure? I am not getting errors but I am also not getting a value returned. For testing purposed I have the RetVal variable explicitly set to zero in the SP but it does not get changed when returned to VFP. Here is how I call it:
>
>
>mretval=-5
>pword=ENCRYPT('password','ge02598')
>resultCode = SQLExec(consql, ;
> "{CALL pchecklogin ('ge02598',?pword, ?@mretval)}")
>
>
>Here is what the SP looks like (with the meat left out):
>
>create or replace procedure pCheckLogin
>(LoginID IN varchar,
>ePassWord IN char,
>RetVal in out number)
>as
>TablePword UserControl.Password%TYPE;
>BEGIN
>RetVal:=0;
>END;
>
>Always returns a -5! Any ideas what I am doing wrong?
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe