Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: beginner: cursors
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