How to run SQL Script from forms 6i?

From: <insbor_at_hotmail.com>
Date: 26 Feb 2006 11:11:07 -0800
Message-ID: <1140981067.141208.95230_at_j33g2000cwa.googlegroups.com>



Hi,

[Quoted] We want to run some SQL Scripts from forms 6i. We are using a form's host command in order to that but not successful.

For Example:

..............................

get_connect_info.....

output:='c:\run_sql.txt '||un||'/'||pw||'_at_'||cn ; Host(output,no_screen);

The run_sql.txt contains the following :

set trimspool on
set heading off
set feedback off
set echo off
spool c:\traceonly.txt
set autotrace traceonly
select * from scott.emp ;
spool off
set autotrace off
exit

[Quoted] Please let us inform how should we run the above script from forms 6i's Host Command?

insbor Received on Sun Feb 26 2006 - 20:11:07 CET

Original text of this message