Not able to run script in sqlcl

User_ZUUOD

Hi All,

I am able to run SELECT * FROM DUAL; in sqlcl but When I try to run @ \Scripts\Explain_plan.sql nothing is happening.

Please advise why scripts are not getting executed.

jaramill

My guess is that you are logged into the database via SQL* Plus, which you've executed from the command line that is of a Unix/Linux variety, but trying to run a script located on Windows path.

So can you type these two things first (one at a time)

SELECT *

  FROM v$version;

Then type in the command "host".  What does it show?  are you in Windows prompt or a Unix/Linux prompt?

For example, mine is Unix:

John Thorton

2980262 wrote:Hi All,I am able to run SELECT * FROM DUAL; in sqlcl but When I try to run @ \Scripts\Explain_plan.sql nothing is happening.Please advise why scripts are not getting executed.

is there a space character between "@ and the \"?

if so, please remove it & try again.

User_ZUUOD

Tried that as well but not working.

User_ZUUOD

No my DB version is 12.1 and host command shows windows as sqlcl is in my D directory of window machine.

John Thorton

2980262 wrote:Tried that as well but not working.

When was last it worked without error?

What changed since then?

You have a mystery & give us no clues.

How do I ask a question on the forums?

jaramill

2980262 wrote:No my DB version is 12.1 and host command shows windows as sqlcl is in my D directory of window machine.

Ah I just realized you're using SQL CL (Command Line) which is the evolved version of SQL* Plus.

Do you have access to SQL* Plus?  If so can you try the same thing again?

jaramill

John Thorton wrote:2980262 wrote:Hi All,I am able to run SELECT * FROM DUAL; in sqlcl but When I try to run @ \Scripts\Explain_plan.sql nothing is happening.Please advise why scripts are not getting executed.

is there a space character between "@ and the \"?

if so, please remove it & try again.

Good catch John, I didn't see that blank space there.

jaramill

2980262 wrote:Tried that as well but not working.

What John mentioned is a good thing.  Can you show us that it is STILL not work when you remove the space?  Also before you run the script (or attempt to), type in the command "host", then type in the change directory command without a value.

"cd" and show us what it says?

John Thorton

post  COPY & PASTE proof that Explain_plan.sql file exists & has correct OS  permissions for Oracle to invoke it.

make a new text file called "now.sql" that contains the line below

SELECT SYSDATE FROM DUAL;

& do as below

SQL> @now.sql

COPY the results from above then  PASTE all back here

User_ZUUOD

Already tried the approach with SELECT * FROM emp; in a demo.sql but result is same.