drop table if exists test cascade;
create table test(id int, name varchar);
drop sequence seq_test_id;
create sequence seq_test_id ;
SQL> call func_test('b');
LINEID v_id
---------- -----------
1 2
SQL> select * from test ;
LINEID id name
---------- ----------- ----
1 1 a
2 2 b
SQL>
|
|