Re: how can i execute SQR program from PL/SQL

[Eric Dimick Eastman <erice@ONTKO.COM>]

Chandru,

The short answer is "you can't, but you can fake it."

There are several ways to fake it, each have their own problems.  One way that I
might choose would be to have an SQR program that is always running listening to
an Oracle database pipe.  The PL/SQL would then stick messages in the other end
of the pipe to tell the SQR program what to update.  This assumes you want to
update the same instance of Oracle where the PL/SQL resides.

If you are interested, I can forward code for listening to pipes when I go home
tomorrow.

Hope this helps,
Eric

Quoting "Chandrashekhar.A.M" <chandram@ZENITHSOFT.COM>:

> hi all
>     can anybody help to sort out my problem. my problem is
> i have SQR on HP unix. I am trying to update some tables(database Oracle
> is on Unix) through SQR. So  i want to call SQR from PL/SQL
> procedure/function which
> is called by a Power builder application.
>     i will be very thankful to your help.
>
> regards
> chandru
>
>