Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle oledb bug?

Oracle oledb bug?

From: <sdbillsfan_at_gmail.com>
Date: 21 Feb 2006 11:19:20 -0800
Message-ID: <1140549560.878028.175560@f14g2000cwb.googlegroups.com>


All,
 I am encountering an issue with gathering stats from an OLEDB connection when the stats to be gathered include a composite index. I receive the ambiguous " OraOLEDB: ORA-03113: end-of-file on communication channel" from the calling program and even if my anonymous block has an exception handler it is never fired. Below is a simple vbs script to replicate the problem. I am running Oracle9i Enterprise Edition Release 9.2.0.6.0 on Win2k with ADO v2.8 but have replicated this using several other configurations/platforms.

Set db = CreateObject("ADODB.Connection") db.open "Provider=OraOLEDB.Oracle;User Id=system;Password=manager;Data Source="

db.execute "begin execute immediate 'create table teststats(a NUMBER, b NUMBER)'; end;"

db.execute "begin for x in 1..4000 loop insert into teststats values(x,x); end loop; end;"

'works fine with the following single column index
'db2.execute "begin execute immediate 'create index teststats_idx on
teststats(a)'; end ;"

'breaks with this composite index

db.execute "begin execute immediate 'create index teststats_idx on teststats(a,b)'; end ;"

db.execute "begin DBMS_STATS.GATHER_TABLE_STATS( OWNNAME=>null, TABNAME=>'teststats', estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,

CASCADE=>true); end;"

db.execute "begin execute immediate 'drop table teststats'; end;" db.close Received on Tue Feb 21 2006 - 13:19:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US