var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Passing value from PL*SQL to the calling unix shell script
I am calling a PL*SQL from unix shell script (csh).
I want the PL*SQL to return a value to the shell script. In order to do so I am calling the PL*SQL using
set val = `sqlplus -s ... `
But whatever I write using DBMS_OUTPUT is being transferred to <val>.
I want only a single integer value at the end of PL*SQL not everything. But I also cannot remove the DBMS_OUTPUT statements. I do not have an option of using UTL_FILE package.
How can I pass the integer value to the shell script variable ?