OraFAQ Forum: SQL & PL/SQL » ALTER SEQUENCE in a procedure

Home » SQL & PL/SQL » SQL & PL/SQL » ALTER SEQUENCE in a procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ALTER SEQUENCE in a procedure [message #1799]

Thu, 30 May 2002 21:38

vijaya
Messages: 10
Registered: May 2001

Junior Member

How can I alter a sequence inside a procedure? When I write commnad as shown below i get the error PLS-00103
ALTER SEQUENCE org_id_seq INCREMENT BY 10;

Report message to a moderator

Re: ALTER SEQUENCE in a procedure [message #1802 is a reply to message #1799]

Thu, 30 May 2002 22:29

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If you are running 8i or later, you can use Native Dynamic SQL (NDS):

execute immediate 'alter sequence ...';

If you are running a pre-8i version, you will need to use DBMS_SQL.

Report message to a moderator

Previous Topic:	Migrating from Oracle 7 to Oracle 8i
Next Topic:	how can store 'jpg' file into oracle db?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:05:28 CDT 2024