Re: reading unix host variables within PL/SQL

rob joss (rob_joss_at_lilly.com) wrote:
: I have not been able to find a way of reading unix host variables from
: either SQLPLUS or within PL/SQL.

Best done in a Unix shell script:

#!/bin/sh

text='Hello'
sqlplus -s / << !
SELECT '${text}' FROM dual;
exit
!

Stored PL/SQL would be a little trickier !

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can can be determined by replacing 'not.valid' with 
'value.net'