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>


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

Original text of this message