Hello,
I succesfully configured Ultraedit to invoke Oracle SQL * Plus to execute PL/SQL files. It was fine for a day and suddently something happend and Ultraedit is passing temp file names to sql plus.

Tool Configuration in UltraEdit:
SQLPLUS.EXE USERNAME/PASSWORD@TNS @%N%E
Output to Listbox.

Now the filenames passed and error is as follows:
unable to open file "PC818A~1.PLS".


My file name is "PCDCRMFDET_Pkg.pls".

Any help is appreciated.
Thanks,
Sam

It isn't a temp file, it is passing the short 8.3 filename.

According to the help you should pass the file using lower case %n%e and enclose it in quotes in case the file name has spaces.

So it should look like this:
SQLPLUS.EXE USERNAME/PASSWORD@TNS @"%n%e"

not sure if the first quote should go in front of the @ or after.

HTH

Al

Thanks Al...You are right. It worked with minor change.
SQLPLUS.EXE USERNAME/PASSWORD@TNS "@%n%e".
Remember no spaces between @ and %

Thanks again.

Sam.