Re: *FORMS v4<=?=>SQLPLUS

In article <1.8558.2249.0N27CAFA_at_dscmail.com>

           richard.vernick_at_dscmail.com "Richard Vernick" writes:
:What is the best way to call a SQL*Plus script from Forms v4 in windows?
:(I need sqlplus because forms uses PL/SQL v.1 and I have written PL/SQL
:v.2 code) I thought it would be easy. Apparently, sqlplus is not part of
:the CDE suite so, RUN_PRODUCT() is out. HOST() is out because it shells
:out a DOS command file. I am starting to look at DDE but, I don't know
:whether sqlplus is DDE compliant.

Try the plus31 executable (eg. host plus31 user/pwd _at_file). If you use the -s flag (silent), it is ALMOST silent - you still see the SQL*Plus window flash up and down.

I can't see how to get it to run silently - but I haven't really looked into it in detail. If you find it, please mail or post your solution.

-- 
Glenn Nicholas.