When you receive an from Oracle when running a statement that you believe should work ( as with yours, as it works on an instance on a Sun box ), you should logon to the database with sqlplus, using the same account as the Perl program, and try your statement with sqlplus.
If it doesn't work in sqlplus, you've greatly narrowed down the scope of software that could be at fault. Same thing if it *does* work. Jared On Friday 18 July 2003 10:35, Ian Harisay wrote: > Hi, > > This is a follow up with my problem on trying to use linked tables in my > query. I have a problem with this on my Linux box (rh8). I do not have > a problem with this on my Sun box. My perl modules are at the same > version level on both boxes. The only difference I can see is with the > Oracle client itself. I have 9.2.0.1.0 on Linux and 9.0.1.0.0 on Sun. > > The statement I try to execute is: > > SELECT DISTINCT list_nam FROM [EMAIL PROTECTED] > > The error returned is: > > DBD::Oracle::st fetchrow_hashref failed: ORA-03106: fatal two-task > communication protocol error (DBD ERROR: OCIStmtFetch) [for statement > `` SELECT DISTINCT list_nam FROM [EMAIL PROTECTED] > '' with params: ]) at clean_lists.plz line 144. > > any ideas on where to look for the problem? Is it feasible to try and > install an older Oracle client on Linux? Thanks for any help on this.
