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

["Chandrashekhar.A.M" <chandram@ZENITHSOFT.COM>]

hi eric,

thank you for your reply, please forward the code  so that i can try with
that , which may solvemy problem.
waiting for your reply
chandru
----- Original Message -----
From: Eric Dimick Eastman <erice@ONTKO.COM>
To: <SQR-USERS@list.iex.net>
Sent: Tuesday, December 12, 2000 2:40 PM
Subject: Re: how can i execute SQR program from PL/SQL


> 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
> >
> >
>
>