calling sqlplus from sqlforms30
Date: 27 Feb 93 05:06:05 GMT
Message-ID: <1993Feb27.050605.9109_at_teetot.acusd.edu>
Does anyone know how to pass system.last_query from sqlforms30
to sqlplus? Pair of single quo surrounding string constant, if any,are stripped
off :system.last_query in following host command. Do NOT look into
Oracle's bulletin. It does NOT work on AT&T 386/SYSTEM V. Your pointer is highly
appreciated!!
Allen Tsai
University of San Diego
tsai_at_teetot.acusd.edu
----------------- host command ------------------------
host('sqlplus / _at_script ' || '''"' || :system.last_query || '"''');
------------------ _at_script.sql -----------------------
set feedback off
set term off
set echo off
set flush off
COLUMN ROWID OFF
spool test.txt
i
&1;
/
spool off
exit;
Received on Sat Feb 27 1993 - 06:06:05 CET