Re: SQL in perl/tk

If it works in Toad or sqlplus but not in your perl code, I'd expect DBD::Oracle to throw some errors* which will point you in the right direction. Are you connecting to the same database as the same user in both Toad and your Perl code? Post a short example of your perl code which reproduces the problem, and any output. See Writeup Formatting Tips.

Update * if it doesn't see DBD::Oracles trace method.

Comment on Re: SQL in perl/tk

Replies are listed 'Best First'.
Re^2: SQL in perl/tk by cavac (Prior) on Jan 13, 2012 at 14:40 UTC
Is vsurend using DBD::Oracle? Could be DBD::ODBC or something for all we know. Also, are all the connections really using the same database/username/password/schema? Different connections may point to different tables (similar looking) tables with different content. (e.g. test database vs. production database). Another thing, especially with Oracle: vsurend, did you compile DBD::Oracle yourself against the Oracle client you have installed on your machine or did you use some precompiled package like ActiveState's PPMs? DBD::Oracle and Oracle's libraries don't always play nice together, even on minor version differences when using a precompiled version. "Believe me, Mike, I calculated the odds of this succeeding against the odds I was doing something incredibly stupid… and I went ahead anyway." (Crow in "MST3K The Movie")	[reply]

Replies are listed 'Best First'.

Re^2: SQL in perl/tk
by cavac (Prior) on Jan 13, 2012 at 14:40 UTC

Is vsurend using DBD::Oracle? Could be DBD::ODBC or something for all we know.

Also, are all the connections really using the same database/username/password/schema? Different connections may point to different tables (similar looking) tables with different content. (e.g. test database vs. production database).

Another thing, especially with Oracle: vsurend, did you compile DBD::Oracle yourself against the Oracle client you have installed on your machine or did you use some precompiled package like ActiveState's PPMs? DBD::Oracle and Oracle's libraries don't always play nice together, even on minor version differences when using a precompiled version.

"Believe me, Mike, I calculated the odds of this succeeding against the odds I was doing something incredibly stupid… and I went ahead anyway." (Crow in "MST3K The Movie")

[reply]