Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-02201:sequence not allowed here

591309Jul 9 2008 — edited Jul 9 2008
Hi all,
I am trying to insert the data from one schema to other.
ukd is the user name i want to insert data into.There is no sequence of the name ukd.Even if i remove ukd, im still getting the same error.
But iam getting the below error:
ORA-02201: sequence not allowed here
ORA-06512:at line 11
declare
cursor c1 is
select owner,object_name from dba_objects
 where owner =upper('&owner');
begin
for var in c1 loop
EXECUTE IMMEDIATE 'insert into ukd.'||var.object_name||'
                  SELECT * FROM '||VAR.OBJECT_NAME||'';
END LOOP;
commit;
END;
Message was edited by:
MYH
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2008
Added on Jul 9 2008
2 comments
7,721 views