result of function

[pinocchio]

Hello,
First, sorry for my english but i try my best.

I use the database ORACLE and i would like read the result of a function.

For a procedure i make :

         RUN STORED-PROC send-sql-statement h1 = PROC-HANDLE NO-ERROR ("begin " + SQLProcedure + "(" + chaine + "); end;").

chaine contains a list of parameters.
But if my SQLProcedure give a result back, how can i read it please?
Thank you for your help.
Pinocchio

 

[jamesmc]

I have no way of testing this but perhaps something like:

RUN STORED-PROC send-sql-statement h1 = PROC-HANDLE NO-ERROR ("begin " + SQLProcedure + "(" + chaine + "); end;").

FOR EACH proc-text-buffer WHERE PROC-HANDLE = h1 NO-LOCK:
    DISPLAY proc-text-buffer.
END.

proc-text-buffer is an ABL supplied buffer where results are written to. For more information check out the help information regarding the RUN STORED-PROCEDURE statement (where I got this snippet from).

HTH.