RE: dynamic sql problem

[McBain, Neil SITI-ITDIEEE]

Your account probably has the create table privilege granted through the resource role, grant create table to your account and try again, privileges granted through a role are not active when running a procedure. -----Original Message----- From: Siddharth Haldankar [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 11:39 To: Multiple recipients of list ORACLE-L Subject: dynamic sql problem Hi Gurus,   I have problem running Dynamic SQL through a package, though it runs fine in a unnamed block.   This is the sample code DECLARE lv_sql_stmt    VARCHAR2(2000); begin    lv_sql_stmt := 'create table a_temp (a number)';    EXECUTE IMMEDIATE lv_sql_stmt; end; /   This runs fine.   But as soon as I put this inside a package I get an error PROCEDURE test is lv_sql_stmt    VARCHAR2(2000); begin    lv_sql_stmt := 'create table a_temp (a number)';    EXECUTE IMMEDIATE lv_sql_stmt; end;   ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "COMMADM.CT_REFRESH_PK", line 415 ORA-06512: at line 1   This line 415 is the execute immediate line.   Any clues why this is acting strangely.   Thanks in advance for your time in answering to my query     With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]