calling sqlplus from sqlforms30

From: <tsai_at_teetot.acusd.edu>
Date: 27 Feb 93 03:27:34 GMT
Message-ID: <1993Feb27.032734.6374_at_teetot.acusd.edu>

        Does anyone reading this newsgroup know how to pass :system.last_query from sqlforms30 to sqlplus ? The pair of single quo for constant strings in :system.last_query, if any like users entering conditional query, are stripped off my following host command in sqlforms30. Script file is included for your reference too. Any 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 - 04:27:34 CET