create synonym with dbms_sql (Oracle8.0.5)

Hi!
I am unable to create a synonym embedded in a pl/sql function. When I use dbms_sql I get the error message: 1031: Insufficient privileges. The code is as follows:

dbms_sql.parse(cur,'CREATE SYNONYM "MYSYNONYM" FOR MGR.R_CALLEDEV',dbms_sql.native);

user MGR has privileges to create the synonym. Owner of dbms_sql is SYS and also has privileges to create a synonym.

Any help please?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 21 2000 - 00:00:00 CDT