Re: set_session_longops in perl

From: Ben <>
Date: Mon, 27 Oct 2008 07:56:35 -0700 (PDT)
Message-ID: <>

On Oct 25, 12:59 am, Tim X <> wrote:
> Ben <> 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 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