How to Pass Value of Variable From PL/SQL Procedure to Shell Script

[pipo]

note : you can do it a bit simpler than what you used Pando :

#!/bin/ksh

fec=$(sqlplus -s loop/loop@loop << EOF
set pagesize 0
set feed off
set serveroutput on
select sysdate
from dual;
EOF)

echo $fec