Re: set_session_longops in perl

From: Ben <benalvey_at_yahoo.com>
Date: Mon, 27 Oct 2008 07:56:35 -0700 (PDT)
Message-ID: <fb1e2c53-260a-4073-8bdc-29e7382960e0@b1g2000hsg.googlegroups.com>


On Oct 25, 12:59 am, Tim X <t..._at_nospam.dev.null> wrote:
> Ben <benal..._at_yahoo.com> writes:
> > I've posted this in the perl group also, but not really sure which
> > group would be better to get an answer from. Is it possible to use
> > dbms_application_info.set_session_longops for 10.2.0.2 in a code loop
> > of a perl script? I've only seen it used in pl/sql loops and I'm
> > thinking the values that you use to determine the row in v
> > $session_longops would pose a problem.
>
> Cant't see there would be any problem. You wold need to put the call
> between BEGIN and END blocks as you do when calling any plsql via perl
> DBD::Oracle.
>
> However, its been a while since I've done any Perl DBI to oracle (in
> fact, I'm about to do it again to test some interfaces designed for JDBC
> connections that pass ref cursors back and fort _ I can't stand Java, so
> I'm going to use perl to write the tests), but the last time I did it, I
> seem to remember there were optional settings that could be passed to
> the connect method to set application_info details. Check the
> DBD::Oracle man page.
>
> Tim
>
> --
> tcross (at) rapttech dot com dot au

I haven't been able to find any references to optional settings for application_info. Received on Mon Oct 27 2008 - 09:56:35 CDT

Original text of this message