Re: Dynamic SQL inside Stored Procedures

From: <oracle_at_nettwerk.com>
Date: Thu, 20 Aug 1998 16:07:42 -0700
Message-ID: <35DCAC3E.E2084F82@nettwerk.com>

Wupps... I didn't trim out everything that wasn't needed...

Here's the adjusted code:

---

create or replace
procedure test_seq
is

        i_query 	varchar2(2000);
        i_cursor 	integer;
        i_void		integer;
begin
        begin
                i_query := 'create sequence test_sequence start with
999';
                i_cursor := dbms_sql.open_cursor;
                dbms_sql.parse(i_cursor,i_query,dbms_sql.v7);
                i_void := dbms_sql.execute(i_cursor);
                dbms_sql.close_cursor(i_cursor);
        exception
                when others then
                        dbms_output.put_line('create sequence
failed...');
        end;

end;
/ Received on Thu Aug 20 1998 - 18:07:42 CDT