Re: Create synonym dynamicaly

Walter,
Some thoughts...
1) Does the synonym already exist?
(I assume not)

2) Does the owner of the stored procedure have EXPLICIT rights to Create Synonym?
i.e. Not Rights granted through a ROLE.

HTH,
Robert Proffitt
Beckman Coulter
Brea California

In article <39F6F86E.DDE93BD_at_gvcc.net>,   walter <walter.sgv_at_gvcc.net> wrote:
> Hello,
>
> I have a problem with a stored procedure :
> ...
> i_stringaSql := 'Create synonym .....'
> curSql := dbms_sql.open_cursor;
> dbms_sql.parse(curSql,i_stringaSql,dbms_sql.v7);
> dummy := dbms_sql.execute(curSql);
> dbms_sql.close_cursor(curSql);
> ...
>
> This stored procedure should create dynamicaly a Synonym. The
 Procedure
> give no errors but no synonym where created....
>
> Thanks
>
> walter
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 19:30:54 CEST