ORACLE CURSORS

From: <brianjh_deja_at_my-deja.com>
Date: Tue, 09 Jan 2001 20:40:58 GMT
Message-ID: <93ft0q$8sm$1@nnrp1.deja.com>

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/ Received on Tue Jan 09 2001 - 14:40:58 CST