Hi All,

I created the following stored procedure & compiled it in an Oracle database.

CREATE OR REPLACE PROCEDURE GetEmplInfoSP( pnEmpPersNo NUMBER,
pcEmplName OUT VARCHAR2,
pnPersNo OUT NUMBER,
pcLoginId OUT VARCHAR2)

IS

BEGIN

SELECT RTRIM(PERS.last_name) || ', ' || RTRIM(PERS.first_name) AS Employee, EMP.pers_no, EMP.login_lvl
INTO pcEmplName, pnPersNo, pcLoginId
FROM EMP,PERS
WHERE EMP.pers_no = PERS.pers_no (+)
AND EMP.pers_no = pnEmpPersNo
ORDER BY PERS.last_name, PERS.first_name;

END GetEmplInfoSP;

What I was hoping to get was a cursor with the 3 fields I requested. But I've no idea the syntax for query.

sqlexec(nSatHandle, ??????, 'test_cursor')

TIA
Mike

P.S. VFP 6 SP5