create or replace
procedure test_seq
is
temp_julian varchar(5);
temp_sequence number;
i_query varchar2(2000);
i_cursor integer;
i_void integer;
temp_date_julian varchar2(11);
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:02:27 CDT
