Re: calling sqlplus from sqlforms30

In article <1993Feb27.050605.9109_at_teetot.acusd.edu>, tsai_at_teetot.acusd.edu (Tsai) writes:
>
> 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 || '"''');

How about :

      host('sqlplus / _at_script \"'||:system.last_query||'\"'); -or-

      host('set arg="'||:system.last_query||'";sqlplus / _at_script \"$arg\"');

(used to be a similar problem when using AT&T's shell with SQL*ReportWriter and  the solution was similar).
>
>
> ------------------ _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;

-- 
================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California