Alter table in stored procedure 
Author Message
 Alter table in stored procedure


I have table with serial column:
create table kard_ser
kard_ser serial not null

I would like to change starting serial number after some time and this
should be done by all users (public), so I decide to use stored
procedure which will receive starting serial number:

create dba procedure pom_test(ser_num int)

alter table kard_ser modify kard_ser serial (ser_num) not null;

end procedure;

When I try to execute procedure I get syntax error on alter table
statement. I don't know SPL very well, please help.

Wed, 18 Jun 1902 08:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. alter table and stored procedures

2. Alter table with stored procedure help!!!!

3. alter temporary table within a dynamically built stored procedure

4. Problem Using Parameter in ALTER TABLE Stored Procedure

5. alter table in a stored procedure

6. ALTER TABLE in a stored procedure

7. How do I Alter a table in a Stored Procedure

8. Alter temp table in stored procedure

9. Alter table not work in a stored procedure

10. alter table in a stored procedure

11. Stored procedures and altered table/view

12. stored procedure that alters another procedure?

Powered by phpBB® Forum Software