Database Administration (MOSC)

MOSC Banner

Running nested scripts with sqlplus via http

edited Apr 3, 2013 6:42AM in Database Administration (MOSC) 2 commentsAnswered
Hi,
in 11.2.0.3.

@test2 par1

test2.sql: prompt I am test2.sql invoked with param: &1


Now I run test.sql via http:

http://server:7778/sql/test.sql
SP2-0556: Invalid file name.


http://server:7778/sql/test2.sql
Enter value for 1: par

I am test2.sql invoked with param: par


Now i modify test.sql and remove the param

@test2


http://server:7778/sql/test.sql
Enter value for 1: par
I am test2.sql invoked with param: par


Why am I unable to use parameters in test.sql script and run it with http?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center