Good Day, Tom..!!
As per my requirement written the code to get last record date from first 100 records(bulk collect limit clause to 100) and from collection variable assigned the output date to variable; and I want this variable value to be echoed in shell variable.

Please suggest. ..nothing is echoing in shell..I tried with exec dbms_output.put_line(), can't fetch value however I can display some msg with it like "Hello World".

Appreciate your patience :-)

#!/bin/bash
batch_size=100
db_str=${uname}/${psd}@${dbname}
v_end_id=$(sqlplus -s ${db_str} <<-EOS
DECLARE
cursor ajc_cur is
SELECT created_date
FROM ****
WHERE rownum < = 1000
ORDER BY created desc;
TYPE rec_tb IS TABLE OF ***.created_date%TYPE;
l_created_dates rec_tb;
v_created date;
BEGIN
OPEN ajc_cur;
LOOP
FETCH ajc_cur bulk collect into into l_created_dates limit '$v_batch_size';
EXIT WHEN ajc_cur%NOTFOUND;
v_created := l_created_dates('$v_batch_size');
dbms_output.put_line(v_created);
END LOOP;
CLOSE ajc_cur;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Data error..');
END;
/
exit;
EOS
)
echo $v_end_id

...
v_end_id=$(sqlplus -s ${db_str} <<-EOS
set serveroutput on
DECLARE
...