Sample Header Ad - 728x90

Pass a linux variable into oracle script

-1 votes
1 answer
88 views
I am trying to pass mount_point details in my oracle script. I am able to pass integer variable using below code but not able to send mount point details in oracle script: sed "s/@@pqr@@/$space/g" tablespace_extend.sql | sqlplus -s "/ as sysdba" BEGIN space:="@@pqr@@"; dbms_output.put_line(space); END; / When I am using same code to pass mount point details, it is not working. it returns this error message: sed: -e expression #1, char 13: unknown option to `s', mount_point = /u08/dbname/
Asked by Divya (1 rep)
Oct 27, 2020, 02:39 PM
Last activity: Nov 3, 2020, 10:50 PM