Command window doesn't accept blank lines in object type

[Bo Pedersen]

The following object type compiles correctly in the program window:

create or replace type test_object as object
(
  -- Author  : BOEP
  -- Created : 14-01-2005 14:59:58
  -- Purpose : Testing

  -- Attributes
  Attr1 number, -- First attribute
  Attr2 varchar2(60), -- Second attribute

  -- A testing procedure
  member procedure testing(p_str varchar2)
);

But it doesn't compile in the command window. Apparently it doesn't like the blank lines. The script executes fine in SQL*Plus so the command window is not SQL*plus compatible regarding this aspect.

I use of course the program window to edit the object type but the command window also fails when I have an install script including the file for the object type. And I generally use a install.sql file to install all the files. So in this case I have to resort to SQL*Plus instead of the command window.

I suggest an enhancement so the command window can compile object types with blank lines.

Bo Pedersen

 

[Marco Kalter]

We'll fix it!

 

[Marco Kalter]

You can download a pre-release for this fix if you want.

 

[Miles]

Marco,

I am using version 6.0.4.906 and I am getting errors trying to compile java source in the Command Window (like http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000196#000003). Are you working on this problem as well?

-Miles

 

[Marco Kalter]

I have uploaded a fix for this as well.