You will want to read the section on application development pl/sql. That
will narrow down your search of the volume of text to deal with. True, you
can use dbms_sql, but it is going to be slower than defining a cursor and a
rowtype.
Jim
--
Our new email address is kennedy-family_at_home.com
Have a happy Holiday.
<brianjh_deja_at_my-deja.com> wrote in message
news:93ft0q$8sm$1_at_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 - 18:53:02 CST
