Re: beginner: cursors

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 10 Apr 2007 10:15:23 -0700
Message-ID: <1176225316.731469@bubbleator.drizzle.com>

matt 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
> BEGIN
>
> Does that TYPE cursor_var also need to be specified as an OUT?

CREATE OR REPLACE TYPE or declare it in a package header.

Look at these examples:
http://www.psoug.org/reference/ref_cursors.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Apr 10 2007 - 12:15:23 CDT