there are two ways to do this

1.use utl_file and write it to a file and then extract the value
from that file to a unix variable.

2. Write a pro*c program.


regards

gtm