Sunday, January 01, 2017

SQL Developer Stops Running in Oracle 9

I created the following simple SQL script:

spool test_output
prompt Creating proc1:
create or replace procedure proc1 is
begin
null;
end;
/
prompt Creating proc2:
create or replace procedure proc2 is
begin
null;
end;
/
spool off

I started a SQL Developer session (version 4.2.0.17.089) and ran the script in an Oracle 10 database (as usual, click on the image to enlarge it/bring it into focus):

 
It worked as expected and the output you can see on the screen appeared in the SPOOL file as shown below:

Creating proc1:
 
Procedure PROC1 compiled
 
Creating proc2:
 
Procedure PROC2 compiled 

I then ran the script in an Oracle 9 database:

 
No further output was displayed after the first create procedure statement and the SPOOL file looked like this:

Creating proc1:
 
Procedure PROC1 compiled

The second procedure was not created either:

SQL> l
  1  select object_name from user_objects
  2  where object_name in ('PROC1', 'PROC2')
  3  and object_type = 'PROCEDURE'
  4* order by 1
SQL> /
 
OBJECT_NAME
------------------------------
PROC1
 
SQL> 

No comments: