Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: beginner: cursors
On Apr 10, 9:58 am, "matt" <reflectio..._at_gmail.com> wrote:
> On Apr 10, 1:41 am, "dombrooks" <dombro..._at_hotmail.com> wrote:
>
> > Replace 'DECLARE' with 'CREATE OR REPLACE PROCEDURE <your_proc_name>
> > AS'
> > and you're pretty much done.
>
> I attempted to do this and receive a Procedure Created with
> Compilation Errors.
>
> Here is what I altered from the initial post above:
>
> CREATE OR REPLACE PROCEDURE sp_seniority(
> name OUT empbb02.ename%TYPE,
> seniority OUT number,
> TYPE cursor_var IS REF CURSOR,
> myCursorVar OUT cursor_var;) AS
--> name_list empbb02.ename%type,
--> seniority_list number;
> BEGIN
>
> Does that TYPE cursor_var also need to be specified as an OUT?
correction...yet the same result. Received on Tue Apr 10 2007 - 12:10:22 CDT