Re: set_session_longops in perl

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