DBI 1.37-ithread dispatch trace level set to 4
-> prepare for DBD::Oracle::db (DBI::db=HASH(0x83f3e78)~0x83f4b74 ' SELECT DISTINCT list_nam FROM [EMAIL PROTECTED]
') thr#804b3c8
New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x83f4b74), id=)
dbih_setup_handle(DBI::st=HASH(0x83f55a0)=>DBI::st=HASH(0x83f563c), DBD::Oracle::st, 83f55ac, Null!)
dbih_make_com(DBI::db=HASH(0x83f4b74), 84bf798, DBD::Oracle::st, 208, 0) thr#804b3c8
dbd_st_prepare'd sql SELECT
dbd_describe SELECT (EXPLICIT, lb 80)...
fbh 1: 'LIST_NAM' NO null , otype 1-> 5, dbsize 150/151, p150.s0
dbd_describe'd 1 columns (row bytes: 150 max, 75 est avg, cache: 165)
<- prepare= DBI::st=HASH(0x83f55a0) at clean_lists.plz line 140
-> execute for DBD::Oracle::st (DBI::st=HASH(0x83f55a0)~0x83f563c) thr#804b3c8
dbd_st_execute SELECT (out0, lob0)...
dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0)
<- execute= '0E0' at clean_lists.plz line 144
-> fetchrow_hashref in DBD::_::st for DBD::Oracle::st (DBI::st=HASH(0x83f55a0)~0x83f563c 'NAME_lc') thr#804b3c8
1 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0x83f563c)~INNER 'NAME_lc') thr#804b3c8
2 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0x83f563c)~INNER 'NAME') thr#804b3c8
2 <- FETCH= [ 'LIST_NAM' ] at clean_lists.plz line 147
.. FETCH DBI::st=HASH(0x83f563c) 'NAME_lc' = ARRAY(0x83f578c) (cached)
1 <- FETCH= [ 'list_nam' ] at clean_lists.plz line 147
1 -> fetch for DBD::Oracle::st (DBI::st=HASH(0x83f563c)~INNER) thr#804b3c8
dbd_st_fetch 1 fields...
OCIErrorGet after OCIStmtFetch (er1:ok): -1, 3106: ORA-03106: fatal two-task communication protocol error
!! ERROR: 3106 'ORA-03106: fatal two-task communication protocol error (DBD ERROR: OCIStmtFetch)'
1 <- fetch= undef at clean_lists.plz line 147
!! ERROR: 3106 'ORA-03106: fatal two-task communication protocol error (DBD ERROR: OCIStmtFetch)'
<- fetchrow_hashref= undef at clean_lists.plz line 147
1 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0x83f563c)~INNER 'ParamValues') thr#804b3c8
error: 3106 'ORA-03106: fatal two-task communication protocol error (DBD ERROR: OCIStmtFetch)'
1 <- FETCH= HASH(0x83f5834)0keys at clean_lists.plz line 147
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 147.
<> DESTROY ignored for outer handle DBI::st=HASH(0x83f55a0) (inner DBI::st=HASH(0x83f563c))
<> DESTROY ignored for outer handle DBI::db=HASH(0x83f3e78) (inner DBI::db=HASH(0x83f4b74))
-> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x83f563c)~INNER) thr#804b3c8
error: 3106 'ORA-03106: fatal two-task communication protocol error (DBD ERROR: OCIStmtFetch)'
<- DESTROY= undef at clean_lists.plz line 147
dbih_clearcom 0x83f55a0 (com 0x853d518, type 3) done.
-> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x83f4b74)~INNER) thr#804b3c8
-- DBI::END
-> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x8143140)~0x83f3e9c) thr#804b3c8
<- disconnect_all= '' at DBI.pm line 649 via clean_lists.plz line 147
! <> DESTROY ignored for outer handle DBI::dr=HASH(0x8143140) (inner DBI::dr=HASH(0x83f3e9c))
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x83f3e9c)~INNER) thr#804b3c8
! <- DESTROY= (not implemented) during global destruction
dbih_clearcom 0x8143140 (com 0x84bc558, type 1) done.
Gold, Samuel (Contractor) wrote:
I would think so. Is the two_task environmental variable set? You may also
want to try using DBI->trace and see what that gives you.
Thanks, Sam Gold
-----Original Message----- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:58 PM To: Gold, Samuel (Contractor) Subject: Re: follow up with oracle linked tables
yes, it does. Frustrating. Do you think that rules out the Oracle client?
Gold, Samuel (Contractor) wrote:
Does it work in sqlplus on both boxes?
Thanks, Sam Gold
-----Original Message----- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 1:35 PM To: [EMAIL PROTECTED] Subject: follow up with oracle linked tables
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.
