This content has been marked as final. Show 2 replies
This is probably best asked in the [url http://forums.oracle.com/forums/forum.jspa?forumID=75]PL/SQL forum, but you are on the right track.
Replace your select into with some dynamic SQL
Hi, try this PL/SQL block. I hope your problem will resolved by this. Revert back with query if any....
set serveroutput on
select count(*) into cnt from DEVCHG.REFRESH_TBL_LIST;
IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE('Total count of table is ' || cnt);
DBMS_OUTPUT.PUT_LINE('No record found');