Passing parameters from shell script

[jhammer98]

Hi,

I have created a package containing several procedures. I wish to call them from shell scripts passing unix variables as parameters but I'm not sure if this will work. Does anybody have any experience with something like this? My code follows:

...
sqlplus / << EOM
set serveroutput on size 1000000
whenever sqlerror exit failure rollback
execute omni_processing.delete_processed_data($SOURCE,'T');
EOM
...

$SOURCE is visible from within the shell script, my question is will it make it to the procedure?

Thanks in advance...

~Jhammer

 

[jhammer98]

ok...it needed some help $SOURCE had to be enclosed by 3 single quotes...

execute omni_processing.delete_processed_data('''$SOURCE''','T');

Thanks for reading anyway...

~Jhammer