Re: PL/SQL HOST Command Hangs

In article <James.Lawrence.67.000AA882_at_epamail.epa.gov>

           James.Lawrence_at_epamail.epa.gov "Lawrence James" writes:

> In article <3cvjem$9ad_at_netaxs.com> tyson_at_netaxs.com (Stephen Tyson) writes:
> >From: tyson_at_netaxs.com (Stephen Tyson)
> >Subject: Re: PL/SQL HOST Command Hangs
> >Date: 17 Dec 1994 20:59:02 GMT
 

> >In article <3cntgi$24s_at_charm.magnus.acs.ohio-state.edu>,
 ktoepke_at_magnus.acs.ohio-state.edu (Kevin M Toepke) says:
> >>Every time the DBAs switched from TCP/IP to Named Pipes every HOST call
> >>would hang. Echo $ORACLE_SID to find out if you are using Named Pipes.
> >>e.g., T:host:instance - TCP/IO
> >> P:host:instance - Named Pipes
> >>
> >>Hope this helps.
> >>
> >>Kevin Toepke
> >Our ORACLE_SIDs do not have a T: or P: in them and our DBA is on vacation,
> >so I'm not sure which we use. Could it be that named pipes are used for
> >local DB access and TCP used over the net? I ask because one of our non-Oracle
> >admins. suggested that the Sun we are running on is too old. We tried running
> >on a different machine, connecting to the DB on the old machine using the
> >_at_SID on the end of the password. This seems to have stopped the hangs.
 

> >Thanks for the help.
>
> How about using the run_product command instead of hosting.
>
> Lawrence....
>

Because he's using SQL*Forms 3.0, not Forms 4.x.

Tony.

Tony Rothwell                                          tony_at_santen.demon.co.uk