IDM Computer Solutions, Inc. Forums

by **srparvath** » Wed Jul 28, 2004 8:14 am

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

by **AlGonzalez** » Wed Jul 28, 2004 11:09 pm

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

by **srparvath** » Thu Jul 29, 2004 7:52 am

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.

IDM Computer Solutions, Inc. Forums

Ultraedit Passing wrong filename or temp file name.

Ultraedit Passing wrong filename or temp file name.

Re: Ultraedit Passing wrong filename or temp file name.

Re: Ultraedit Passing wrong filename or temp file name.