ORA-03124

Junji Ochi <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
Dear DBI users,

My co-worker gets following error messages when trying to query the
CHAR type columns in the table on Oracle 11g R1.

/////qw start/////
DBD::Oracle::st fetchrow_array failed: ORA-03124: two-task internal
error (DBD ERROR: OCIStmtFetch) [for Statement "SELECT a_SESSION FROM
TEST_TB WHERE ID=?" with ParamValues: 
:p1='84c8aab5140cbf000a3ddaf80257b7c2695b6c23']
/////qw end/////

'TEST_TB' table was defined like
   "ID" CHAR(40 BYTE)             as PRIMARY KEY
   "A_SESSION" VARCHAR2(4000 BYTE)

but , we got some workarounds here
    changing colums type 'CHAR' to 'VARCHAR2'
  or
    adding oracle's init parameter
  [ alter session set \"_enable_row_shipping\"=false]

then ,everything will work fine.

Oracle support guys said
" that's perl side problem, because no alert messeges in alart_log at DB 
server side , and no ORA-03124 message between client and server by 
taking Oracle Net trace at oracle client side.
but Oracle Net trace shows 'ORA-01013' just before error, which means 
that client canceled request to query for some reasons."

Is this a DBD::Oracle's bug ?

Could you advise me about why this was happened.

Sincerely,

### CODE ###
## in our enviroments, this works fine at first run ,but failed at
## second run,

$sql1 = "SELECT a_SESSION FROM TEST_TB WHERE ID=?";
$sth = $dbh->prepare($sql1);
$sth->bind_param( 1,'84c8aab5140cbf000a3ddaf80257b7c2695b6c23');
$sth->execute();
$sth->fetchrow_arrayref();


### Oracle table DDL###
  CREATE TABLE "TEST_TB"
    (	"ID" CHAR(40 BYTE),
	"A_SESSION" VARCHAR2(4000 BYTE) CONSTRAINT "TEST_TB_CK1" NOT
NULL ENABLE,
	 CONSTRAINT "TEST_TB_PK1" PRIMARY KEY ("ID")
    )

### our lab ##
Oracle 11.1.0.7.12 SE RAC
CentOS 5.3 64bit

perl, v5.8.8
'DBD/Oracle.pm' => '1.32
'DBI.pm' => '1.609
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.