Create synonym dynamicaly
From: walter <walter.sgv_at_gvcc.net>
Date: Wed, 25 Oct 2000 17:12:46 +0200
Message-ID: <39F6F86E.DDE93BD_at_gvcc.net>
Date: Wed, 25 Oct 2000 17:12:46 +0200
Message-ID: <39F6F86E.DDE93BD_at_gvcc.net>
Hello,
[Quoted] 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 [Quoted] give no errors but no synonym where created....
Thanks
walter Received on Wed Oct 25 2000 - 17:12:46 CEST