Re: Need Help using HOST

Raymond G Boyd wrote:
>
> 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 :

We are running 16-bits oracle applications on NT-stations:

declare
  ...
begin
  userNm := get_application_property( USERNAME );   passWd := get_application_property( PASSWORD );   connectStr := get_application_property( CONNECT_STRING );

  /* or select username/password from table to connect to another

     database */

  logon := userNm||'/'||passWd;
  if ( connectStr is not null ) then
    logon := logon||'_at_'||connectStr;
  end if;

  host( 'plus31.exe '||logon||' _at_'||:script||' '||params );

  /* host runs synchronously,

     be aware: foms application doesn't reget focus when plus31 finishes,

     you have to swith between form and another win-application manually
     or have to start a win-application from within :script