RE: dynamic sql problem

[Paulo Gomes]

Title: Mensagem

to use it inside packages u must have some priviledges given directly to u not to a role.   Regards PG -----Mensagem original----- De: Siddharth Haldankar [mailto:[EMAIL PROTECTED] Enviada: ter�a-feira, 28 de Outubro de 2003 11:39 Para: Multiple recipients of list ORACLE-L Assunto: 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]