Re: PL/SQL CREATE SEQUENCE

Because although it is in a comment statement, it STILL seems to think it is a substiution variable. Looks like a bug to me! Try replacing the -- text by /* text */ or replace the & by and.

Hth,

Sybrand Bakker, Oracle DBA

<newopt_at_my-deja.com> wrote in message news:881n24$m4l$1_at_nnrp1.deja.com...
> Why does this pl/sql script prompt for the cursor name when I have
> supplied in the script itself?
>
> SQL> get test3.sql
> 1 Declare
> 2 cid INTEGER;
> 3 -- This procedure is used to create a new sequence used to
> 4 -- populate the seq_number column in each NCR table
> 5 -- with a unique ascending sequence number starting
> 6 -- with 1.
> 7 BEGIN
> 8 -- Open new cursor and return cursor ID.
> 9 cid := DBMS_SQL.OPEN_CURSOR;
> 10 -- Parse and immediately execute dynamic SQL statement built by
> 11 -- concatenating the sequence name to DROP & CREATE SEQUENCE
> commands.
> 12 DBMS_SQL.PARSE(cid, 'DROP SEQUENCE ' || 'seq_number_next',
> dbms_sql.v7);
> 13 DBMS_SQL.PARSE(cid, 'CREATE SEQUENCE ' || 'seq_number_next START
> WITH 1 MINVALUE 1', dbms_sql.v7);
> 14 -- Close cursor.
> 15 DBMS_SQL.CLOSE_CURSOR(cid);
> 16 EXCEPTION
> 17 -- If an exception is raised, close cursor before exiting.
> 18 WHEN OTHERS THEN
> 19 DBMS_SQL.CLOSE_CURSOR(cid);
> 20 RAISE; -- reraise the exception
> 21* END;
> 22 /
> Enter value for create:
> old 11: -- concatenating the sequence name to DROP & CREATE SEQUENCE
> commands.
> new 11: -- concatenating the sequence name to DROP SEQUENCE commands.
>
> PL/SQL procedure successfully completed.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 11 2000 - 13:56:21 CST