Re: ORACLE CURSORS

In article <93ft0q$8sm$1_at_nnrp1.deja.com>,   brianjh_deja_at_my-deja.com wrote:
> i'm trying to create a procedure that declares a cursor in DBA Studio.
>
> CREATE OR REPLACE PROCEDURE "BRIAN"."OSP_CAPITALIZE_FIRST_CHAR" IS
> BEGIN
> cursor cursor1 is select * from customers;
> END;
>
> Here's the generated text. But I'm getting the following error on
> compile.
>
> Help would be appreciated. THANKS!!
>
> ERROR:
> Line # = 3 Column # = 11 Error Text = PLS-00103: Encountered the
> symbol "CURSOR1" when expecting one of the following:
> := . ( @ % ;
> Line # = 4 Column # = 1 Error Text = PLS-00103: Encountered the
> symbol "END" when expecting one of the following:
> begin function package pragma procedure subtype type use
> <an identifier> <a double-quoted delimited-identifier> cursor
> form current
>
> Sent via Deja.com
> http://www.deja.com/
>

Cursors go in the DECLARE section, I think.

--
-- Martie


Sent via Deja.com
http://www.deja.com/