ORA-12571 Error When Using Direct mode

ORA-12571 Error When Using Direct mode

Postby trumbjd » Mon 10 Nov 2008 22:13

Hi,

I am getting an ORA-12571 when executing a SQL insert while in direct mode. If the same query is used with the normal oci, it works fine. The only thing special about the query is that I am inserting multiple rows at a time (using ExecuteArray) and returning an integer for each row (~1000 rows). Something like this:

INSERT INTO HTSA.HTS_PLATE_PICK ahapp
(
PICK_NUMBER, PLATE_ID, WELL_ADDRESS, ASSAY_ID, PLATE_TYPE,
PICK_DATE, WELL_NUMBER, PICK_TYPE,
SET_NUMBER, TASK_ID,
PRIMARY_MATCH_TYPE, CURRENT_MATCH_TYPE, PICKER_TYPE
)
VALUES
(
HTSA.HTS_PLATES_PICK_SEQ.NextVal,
:PLATE_ID, :WELL_ADDRESS, :ASSAY_ID, :PLATE_TYPE,
:PICK_DATE, :WELL_NUMBER, :PICK_TYPE,
:SET_NUMBER,
:TASK_ID, :PRIMARY_MATCH_TYPE,
:CURRENT_MATCH_TYPE, 'MAPS'
)
Returning ahapp.PICK_NUMBER into :PICK_NUMBER

Does the direct mode not support this? My database is 10.2.0.2.

Thanks!

--Jonathan

CoreLab.Oracle.OracleException occurred
Message="ORA-12571"
Source="CoreLab.Oracle"
ErrorCode=-2147467259
Code=-12571
Offset=0
StackTrace:
at CoreLab.Oracle.bq.a(Int32 A_0)
at CoreLab.Oracle.k.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at CoreLab.Oracle.k.a(Byte& A_0)
at CoreLab.Oracle.a1.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at CoreLab.Oracle.a1.b()
at CoreLab.Oracle.o.b()
at CoreLab.Oracle.d.a(Int32 A_0, bz A_1)
at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at CoreLab.Oracle.OracleCommand.ExecuteNonQuery()
at CoreLab.Oracle.OracleCommand.ExecuteArray(Int32 iters)
at Maps.KineticPicker.Database.PickSaver.PopulateWellLevelPicks() in C:\VS Projects\MAPS 1.5\KineticPicker\Database\PickSaver.cs:line 267
InnerException:
trumbjd
 
Posts: 1
Joined: Mon 10 Nov 2008 22:00

Postby Shalex » Mon 17 Nov 2008 09:22

Could you please send me (alexsh*devart*com) a small test project, DDL and DML script to reproduce the problem?
Shalex
Devart Team
 
Posts: 7699
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle