in reply to Perl connection string to Oracle Database

i noticed that query's result is different if i run it manually through SQL developer client.

Different, how? There is nothing in either client that should change query results, except perhaps the formatting of the results.

  • Comment on Re: Perl connection string to Oracle Database

Replies are listed 'Best First'.
Re^2: Perl connection string to Oracle Database
by Corion (Patriarch) on Oct 26, 2015 at 15:26 UTC

    I could imagine that the collation order and/or other characterset related things can happen if one connection is configured differently from the other. For example, if Latin-1 data is inserted, the database needs to be told in some way that the data should be interpreted as Latin-1.

    In absence of the relevant statements and/or the relevant data and error causes though, this is all idle speculation.

[reply]
      Thanks for the answers. My query is selecting records on Oracle 11G database, based on some attributes and timestamp. I know that it's very strange, infact also comparing SQL developer and TOAD oracle client they result (same query) different output. I don't know how this difference could happen, but at the moment i would like to try changing connection string from DBI to Java one if exist (i would like to set into perl script a new database connection like sql developer client do). Thanks. Regards, Fabrizio
[reply]

        Maybe you can show us the SQL command(s) and examples of where/how the results differ between Java and TOAD and Perl.

        Note that both, ODBC and JDBC have ways of tracing their commands so maybe you can find a difference there.

        Are you using DBD::ODBC or DBD::Oracle to connect to your database?

[reply]

In Section Seekers of Perl Wisdom