http://qs1969.pair.com?node_id=11139432

KSHYAMKUMAR has asked for the wisdom of the Perl Monks concerning the following question:

I am planning to use oracle transparent application continuity feature introduced in 18c, i was reading that i should use OCIStmtPrpeare2() instead of standard Perl DBI module which uses OCIStmtPrpeare(), Do we have any Perl modules with in-built support to work with Oracle TAC ? Thank you for your help.
  • Comment on Perl libraries to support Oracle TAC (Transparent Application Continuity)

Replies are listed 'Best First'.
Re: Perl libraries to support Oracle TAC (Transparent Application Continuity)
by choroba (Cardinal) on Dec 06, 2021 at 14:39 UTC
    You probably meant "Prepare", not "Prpeare".

    map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
      I am planning to use oracle transparent application continuity feature introduced in 18c, i was reading that i should use OCIStmtPrepare2() instead of standard Perl DBI module which uses OCIStmtPrepare(), Do we have any Perl modules with in-built support to work with Oracle TAC ? Thank you for your help.
        You can edit your original question, see How do I change/delete my post?
        map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
Re: Perl libraries to support Oracle TAC (Transparent Application Continuity)
by marto (Cardinal) on Dec 06, 2021 at 22:14 UTC

    Can you link to what you read please? Hopefully it isn't one of those Oracle things that needs a login.

      here are couple of links... our Perl application heavily uses Perl DBI which internally uses OCIStmtPrepare (Unless i am not aware of a latest version which uses OCIStmtPrepare2). https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9542086900346688029 https://blogs.oracle.com/maa/post/application-continuity-a-database-feature-for-developers