How do I accept \" as argument to dos

[batchnewbie]

Dear all,

not workable

Code: Select all

sqlplus sys@localhost/worcl.cambridge.com as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 1 11:19:10 2022

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

working

Code: Select all

sqlplus sys@\"localhost/worcl.cambridge.com\" as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 1 11:15:33 2022

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password

how do I accept \"<hostname>\"/<service_name> in dos batch

currently I program the following:
inside batch_file.bat

Code: Select all

SET one=%~6

SET connection_string=%one%

sqlplus.exe %connection_string%

But the above is not enough because if i entered <batch_file>.bat "sys@\"localhost/worcl.cambridge.com as sysdba\""

it will not work as expected.

many thanks

[aGerman]

Try to escape the surrounding quotes of the argument like:

Code: Select all

whatever.bat ^"sys@\"localhost/worcl.cambridge.com\" as sysdba^"

Steffen