Re: Telnet from Oracle using UTL_TCP

"Mike" <nospam_at_please.com> wrote in message news:_9tw7.22$P67.567_at_wa.nnrp.telstra.net...
> Hi there folks,
>
> I'm playing with the idea of using Telnet from within Oracle (8.1.7.2.3 on
> NT) to perform actions on our legacy box (sort of like a low cost Oracle
> Transparent Procedural Gateway ;))
>
> I can open a connection OK with UTL_TCP, but only get garbage when I read
> input from the port. The same script works fine with an SMTP service by
> changing port to 25. I've mucked around with various character sets, but
> nothing seems to work.
>
> Has anyone discovered how to use the UTL_TCP package to do this?
>
> Thanks in advance,
>
> Mike Cretan
> Database Consultant, Tasmania
>
>
>

You can't.
You need to use dbms_pipe instead.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Mon Oct 08 2001 - 22:44:36 CDT