in reply to Re^6: Perl connection string to Oracle Database
in thread Perl connection string to Oracle Database

Thanks for the answer. I have run the query selecting  count(*) and the result is the same as retrieval but different from SQL developer client. The correct result seems Java one, TOAD+PERL are wrong. Regards, Fabrizio

Replies are listed 'Best First'.
Re^8: Perl connection string to Oracle Database
by Corion (Patriarch) on Oct 27, 2015 at 11:58 UTC

    So the problem would lie in how Java connects to your database, as opposed to how TOAD and Perl connect to your database.

    This is not really a Perl problem. If you are using the Oracle database drivers, you will have to find out what versions the Java program is using and what versions TOAD and Perl are using. Also, make sure that both tests connect to the same database instance. Maybe inspecting the logfiles of JDBC and ODBC or the direct connection, or in the worst case, inspecting a network dump can tell you what the difference is between the two cases.

    You haven't shown us enough of your SQL to determine whether this could be a characterset encoding issue, but as this is not a Perl problem, this site isn't really the place to debug your SQL.

[reply]
      Thanks for the answer. Seems that my SQL developer client use as driver orai18n.jar file. I would like to force into perl script the same driver but i don't known how to do it. how can i configure connection string to use java method instead of DBI library ? Thanks. Regards, Fabrizio
[reply]

        Java drivers are for Java. Perl will use the "normal" Oracle client drivers, like TOAD.

[reply]

In Section Seekers of Perl Wisdom