Re: Need Help using HOST

If the only motivation for going into SQL*Plus is to connect to another database, you can simply disconnect the current session in forms, and reconnect the user automatically to the correct database, run the procedure in Forms (as a stored program unit, or even as a stored procedure at the database level). upon completion, you could disconnect the session, and reconnect the user to the original database (the login and password could have been stored before disconnecting).

Hope this helps

Raymond G Boyd <raymondb_at_global.net.au> wrote in article <32B2445A.249_at_global.net.au>...
> I was wondering if anyone could point me in the right direction on how
> to use the
> Oracle HOST command from Forms 4.5. What I need to do is have a user
> press a button, which needs :
>
> Open a sqlplus session to another database so that a script which
> restores
> data on this database can run (ie This script cannot run in the
> database
> that Forms 4.5 session was started in)
Received on Thu Dec 19 1996 - 00:00:00 CET