dynamic sql problem

[Siddharth Haldankar]

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]