Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Help please! Problem with dynamic sql
Hi.
Are you using Oracle 8i? If yes - is it possible that Fine-Grained-Access-Control issues are involved? You still may use EXECUTE IMMEDIATE by using INSERT-AS-SELECT command (see my prev. mail). Run your procedure with SQL_TRACE set and check the trace file ( use TKPROF ). You will see there a "real" SQL statement.
HTH. Michael
Sent via Deja.com
http://www.deja.com/
Received on Wed Dec 13 2000 - 14:55:50 CST