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,
get_connect_info.....
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