I am developping a script to explain the sql statement.
Most of the sql statement works fine, but there is one problem. in SQLPLUS, SQL> explain plan set statement_id = 'SQL' into system.plan_table for update roadway_alias a set a.a lias =:3 where rowid = :nav_rowid; Explained. But in perl, $sql_explain = "explain plan set statement_id = 'SQL' into system.plan_table for update roadway_alias a set a.alias =:3 where rowid = :nav_rowid"; $dbh->do($sql_explain); I got the following error message, ------------------------------------------------------------ Can't mix placeholder styles (:foo/:1) at /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD/Oracle.pm line 293. -------------------------------------------------------------- The worst thing is , even though I turned RaiseError off, the script still failed, cause all the other sql statement not explained. My question is, 1) What causes this problem? Is there any patch to fix the problem? 2)If this statement can not be explained, how can i make the perl script to continue to go on? I have already turn off the RaiseError and PrintError We are using v5.6.1 built for sun4-solaris Thanks
