Re: help with compilation

You did not indicate any ORACLE errors. So, assuming that the refcursor "csr" is defined correctly in the package "global", you would just need a "/" in the end of the script to get the procedure to compile in SQL*PLUS.

• Jusung Yang

robin.spruce_at_2020log.com (realvert) wrote in message news:<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 - 19:02:41 CET