General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only