develooper Front page | perl.dbi.oracle-oci | Postings from July 2002

=?iso-8859-1?Q?error_ORA-01453?=

Thread Next
From:
marozza@inwind.it
Date:
July 17, 2002 07:28
Subject:
=?iso-8859-1?Q?error_ORA-01453?=
Message ID:
GZED70$7ED6C7642E6292840B51F7973ED5A111@libero.it
Platform: Risk6000  AIX 4.3.3.0
Perl: v5.6.1
Oracle: 8.1.7
DBI: 1.28


We are building DBD-Oracle-1.12. To get the build to go, We:

1. Run  perl Makefile.PL: without any problem;
2. Run  make : without any problem;
3. Run  make test 
   In this case We have dubt about the results, infact the results 
report: 

------------------------------------------------------------------------
----------------
Oraperl test application $Revision: 1.4 $

Oraperl emulation interface version 1.41 
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.28 by Tim Bunce

Data sources:
        dbi:Oracle:AGOL
        dbi:Oracle:DGOL
        dbi:Oracle:EXTPROC_CONNECTION_DATA
        dbi:Oracle:FGOL
        dbi:Oracle:LOOP
        dbi:Oracle:MGOL
        dbi:Oracle:ODR2
        dbi:Oracle:OEM1
        dbi:Oracle:PGOL
        dbi:Oracle:PRODDB
        dbi:Oracle:TEST8IDB
        dbi:Oracle:TESTGOL
        dbi:Oracle:TGOL
        dbi:Oracle:TSVEDB
        dbi:Oracle:dummy


Connecting
 to '' (from command line, else uses ORACLE_SID or TWO_TASK - 
recommended)
 as 'tivdba/tivdba@dgol' (via ORACLE_USERID env var or default - 
recommend name/passwd@dbname)
(ORACLE_SID='DGOL', TWO_TASK='DGOL')

Testing internal row fetch overhead.
50000 fetches:  0 wallclock secs ( 0.31 usr +  0.00 sys =  0.31 CPU)
50000 per clock second, 161290 per cpu second

Fields:    6
Names:     'NUM_T'      'DATE_T'        'CHAR_T'        'ROWID_T'       
'RAW_T' 'NULL_T'
Lengths:   134  76      31      21      3       1
OraTypes:  2    12      1       104     23      1
SQLTypes:  8    9       12      -9104   -2      12
Scale:     0    0       0       0       0       0
Precision: 126  75      30      20      2       0
Nullable:  1    1       1       1       1       1
Est row width:    46
Data rows:
    fetch: '7.2', '17/07/2002', 'TIVDBA', 'AAAADDAABAAAAHSAAA', '7D', 
undef

csr reassigned (forces destruction)...
Fetch list of tables:
Fetched: FILE$
Fetched: BOOTSTRAP$
Fetched: SEG$
Fetched: ICOL$
Test ora_do with harmless non-select statement (set transaction read 
only)
Expect an 'ORA-01453' error message:
ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of 
transaction (DBD ERROR: OCIStmtExecute)
csr out of scope...
ora_logoff...
lda out of scope...

Testing repetitive connect/open/close/disconnect:
If this test hangs then read the README.help file.
Expect sequence of digits, no other messages:
1 2 3 4 5 

Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:
done.

Testing row cache (5).
Test completed in 0 seconds.

Test complete (1 seconds).
If the tests above have produced the 'expected' output then they have 
passed.

------------------------------------------------------------------------
-----------------

"Expect an 'ORA-01453' error message:
ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of 
transaction (DBD ERROR: OCIStmtExecute)"

Is this error a grave problem? 
In spite of this, is the test passed?
We can install DBD-Oracle? 


Regards

Alessandra Marozza
IBM Italy

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About