Suggestion - multiple queries

[shayt]

Hi,
if i have a file, with multiple queries :
select ...
/
select ...
/

when i load the file to a SQL window,
i am getting each query in a different tab (that's great).
but when i save the file, the last "/" is deleted.
so the file becomes -
select ...
/
select ...

so i need to insert the last missing "/" manually,
can you add it.

thanks,
Shay

 

[Marco Kalter]

This works fine for me. Can you send me an example script?

 

[shayt]

sorry,
the problem is NOT in .SQL files.
it is in .PRC files

i have a test1.prc file that contains -
CREATE OR REPLACE PROCEDURE xxx
...
/
CREATE PUBLIC SYNONYM xxx FOR xxx
/
GRANT EXECUTE ON xxx TO USER_ALL_OBJECTS
/

and when i load it to the SQL window,
each command is in a seperate tab.
but when i save the file,
the last "/" is deleted.

Shay

 

[Marco Kalter]

This is caused by the fact that this is not a PL/SQL program unit. You should use a semi-colon instead.