Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL%ROWCOUNT from EXECUTE IMMDIATE returns Zero while from SQLPlus I get results for the same query

Amin AdatiaFeb 24 2015 — edited Feb 24 2015

v11.2.0.3 (exadata x3)

I am trying to get the dbms_sqltune.report_sql_monitor output for a set of queries. In my procedure I read the Query as CLOB and then have EXECUTE IMMEDIATE <Query_CLOB> followed immediately by v_Records := SQL%ROWCOUNT;

v_Records turns out to be zero all the time
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2015
Added on Feb 24 2015
10 comments
2,928 views