Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SP2-0310 unable to open the file setup_aliza.sql, Please help.

TAJDINMay 18 2016 — edited May 18 2016

Sir

When I am in the folder where all files are placed it works fine

dos.png

But when I trying to run the batch file through window explorer it gives the error like bellow

dos.png

dos.png

Sir my batch file text is like bellow

@ECHO off

sqlplus / as sysdba @setup_aliza

ECHO.

ECHO For details, check the setup_ash file in the current directory.

ECHO.

:: Display 'press any key to continue' message

PAUSE

And the next file to open is setup_aliza.sql

The code for aliza_setup.sql is

spool setup_aliza.log;

prompt>Creating users/schemas

start create_users

prompt>Connecting aliza

start connecting_aliza

prompt>Creating aliza tables

start create_aliza_tables

spool off;

exit;

How can I avoid the above error while running the batch file outside the folder.

Regards

This post has been answered by AndrewSayer on May 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2016
Added on May 18 2016
6 comments
463 views