Hi,
I have a Oracle Database 10g Express Edition Release 10.2.0.1.0 installed along with SQL Developer Version 1.2.0 on my pc with an XP platform.
Using SQL Developer, I have been successfully using scripts and viewing the output on the tab named Script Output, after ensuring "set serveroutput on" is activated on the tab named DBMS Output.
I am now in the process of testing my database on the companies oracle installation, which I have no privileges on other than those the DBA has granted me, I want to run the same scripts and view the output by means of the tab named Script Output, but all I get is the response "anonymous block completed". Would anyone know what the issue could be, the reason they display in one instance but on another database they don't. My scripts are of the type below,
DECLARE num NUMBER;
rec_count varchar2(128);
BEGIN
FOR c1 IN
(SELECT object_name
FROM user_objects
WHERE object_type = 'TABLE')
LOOP
EXECUTE IMMEDIATE 'select count(*) from ' || c1.object_name
INTO num;
rec_count := 'Table ' || TRIM(c1.object_name) || ' has : ' || num || ' records';
dbms_output.put_line(rec_count);
END LOOP;
END;
Thank You
Ben
Message was edited by:
Benton