Pass a value from Unix to PLSQL

Shell Programming and Scripting
1

Hi all,
I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output.
I tried useing $variable_name, but it doesn't work.
Any kind of help is appreciated.

Thanks in advance.

2

How do you executing your pl/sql block?
is that code is written inside the shell script and you are connecting with here doc?

$variable_name should work in that case.

can you tell us the exact scenario?

3

Hi,
Check the examples here: Connect to sqlplus and retrieve data

Guru.

1 Like
4

u can use a bcp. its a utility tht can be used for the help you are looking for.