Create sequence via DBMS SQL fails

From: Jan Lund <JANL_at_Lundbeck.Com>
Date: Mon, 20 Nov 2000 10:37:52 +0100
Message-ID: <Sh6S5.41$p86.1890@news.get2net.dk>

Dear all.

I have a problem using DBMS_SQL. I try to Drop a sequence, which works fine, but when i try to re-create it, it fails with an "Insufficent Privleges" error.

What am i doing wrong ?

Function1 works :
  CID:=DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(CID,'DROP SEQUENCE PHARM_DB.TESTSEQ', DBMS_SQL.NATIVE);   RET:=DBMS_SQL.EXECUTE(CID); Function2 fails with an "Insufficent Privleges" error :

  CID:=DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(CID, 'CREATE SEQUENCE PHARM_DB.TESTSEQ

       START WITH 0
       INCREMENT BY 1
       NOMAXVALUE
       MINVALUE 0
       NOCYCLE
       NOCACHE
       ORDER',DBMS_SQL.NATIVE);

  RET:=DBMS_SQL.EXECUTE(CID); Rgds
Jan Received on Mon Nov 20 2000 - 03:37:52 CST