help with compilation
From: realvert <robin.spruce_at_2020log.com>
Date: 14 Jan 2003 01:47:37 -0800
Message-ID: <6b91d8a1.0301140147.4527e1ba_at_posting.google.com>
Date: 14 Jan 2003 01:47:37 -0800
Message-ID: <6b91d8a1.0301140147.4527e1ba_at_posting.google.com>
I am currently trying to write a small stored proc to populate a cursor, this will be used via a c# application however, i cannot seem to get it to compile, any clues would be much appreciated.
regards
rob
//##############################################CREATE OR REPLACE PROCEDURE SECURITY_VALIDATE
( P_USERNAME IN VARCHAR2, P_PASSWORD IN VARCHAR2, outCursor in out global.csr )
AS
BEGIN
OPEN outCursor FOR
SELECT * FROM EMPLOYEE WHERE USERID=P_USERNAME AND PASSWORD=P_PASSWORD;
END; Received on Tue Jan 14 2003 - 10:47:37 CET