OraFAQ Forum: Client Tools » Passing parameter to sqlplus script

Home » Other » Client Tools » Passing parameter to sqlplus script

Fri, 25 January 2019 05:06

ramya29p
Messages: 146
Registered: November 2007
Location: Chennai

Senior Member

Hi,
I want to pass parameter to the .sql file via sqlplus script for connecting the Database.

I have created a batch file having below script.

sqlplus /nolog @schema_compile.sql

schema_compile.sql file with below script

conn schema_name
sho user
exec dbms_utility.compile_schema('schema_name',FALSE)

I tried passing the parameter, but it did not work.

sqlplus /nolog @schema_compile.sql schema_name

schema_compile.sql file with below script

conn &1
sho user
exec dbms_utility.compile_schema('&1',FALSE)

Could anyone please help me.

		Passing parameter to sqlplus script By: ramya29p on Fri, 25 January 2019 05:06
		Re: Passing parameter to sqlplus script By: Michel Cadot on Fri, 25 January 2019 06:01
		Re: Passing parameter to sqlplus script By: ramya29p on Mon, 28 January 2019 02:09
		Re: Passing parameter to sqlplus script By: Michel Cadot on Mon, 28 January 2019 02:19
		Re: Passing parameter to sqlplus script By: Michel Cadot on Mon, 28 January 2019 02:21
		Re: Passing parameter to sqlplus script By: jessika on Thu, 28 March 2019 04:36
		Re: Passing parameter to sqlplus script By: JPBoileau on Thu, 28 March 2019 08:22

Previous Topic:	Blank rows in spooled txt output file using SQL developer
Next Topic:	FNDLOAD for Specific DFF Context

Goto Forum:

]

Current Time: Fri Apr 26 17:14:48 CDT 2024