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

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

Chandru,

I have used this examples to trace calls to PL/SQL from SQR programs.  You could
replace the show_message routine with a procedure to do your update.

Cheers,
Eric


"Chandrashekhar.A.M" wrote:

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

dccm_trace_pkb.sql

dccm_trace_pkg.sql

trace_listener.sqr

dccm_trace.sqh