Help needed on DBMS_SQL

Hi,

I try to use dbms_sql to create a synonym.

Code:

DECLARE    C1 INTEGER;
   Dummy INTEGER;
   CommandStr VARCHAR2(240);

BEGIN
   C1 := dbms_sql.open_cursor;
   CommandStr := 'create synonym elap_actions_current for elap_actions_sep';

   dbms_sql.parse( C1, CommandStr, dbms_sql.v7 );
   dbms_sql.execute( C1 );
   dbms_sql.close_cursor(C1);

[Quoted] [Quoted] This works....

Put the same code in a packaged function yields....

ORA-01031: insufficient privileges

The user has the CREATE SYNONYM privilege granted.........

Thanks in advance

Maarten Received on Wed Aug 12 1998 - 00:00:00 CEST