Devart Forums

Do you know if this error is related to bug 12.0.2 09-Dec-21 Fixed bug with LONG parameters in Oracle 11 and earlier ?

C++ builder 10.4 Update 1
12.0.1 for RAD Studio 10.4
ODAC 12.0.1

Hello,

With instant client 11.2 i obtain error "ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column".
There's no problem with instant client 12.2.

No more problem with instant client 11.2 with old c++ builder 5 and ODAC 6.70.4.45.

Can you help me please ?

Hi,

I use ODAC v 6.90 component to query Oracle database. I have problem with BCB2010 (no problem with BCB5).
I also tried with v 10.4 (trial version) : i have the same problem.

When i send the result of my query to a function i have an Assertion failed error (... errPtr-> ERRcInitDtc > = varType ....) in concatenation operation.



pOraQuery->SQL->Clear();
pOraQuery->SQL->Add(" SELECT col1, col2 from mytable");
pOraQuery->Open();
pOraQuery->First();

UnicodeString sCol1 = "";
UnicodeString sCol2 = "";
while (!pOraQuery->Eof)
{
test(pOraQuery->FieldByName("col1")->AsString, pOraQuery->FieldByName("col2")->AsString); //Assertion failed error

/*sCol1 = pOraQuery->FieldByName("col1")->AsString;
sCol2 = pOraQuery->FieldByName("col2")->AsString;
test(sCol1, sCol2); //no error*/

pOraQuery->Next();
}
pOraQuery->Close();

void test(UnicodeString s1, UnicodeString s2)
{
UnicodeString s3 = s1+" "+s2;
}

Can you help me please.

Hi,

I actually use ODAC 6.70. I want to know what kind of performance are improved in ODAC 9.1?

Cordially.

I had not seen 'Component' property. Thank's a lot.

Hi,

I try to log the last sql query send to the database when an error appear. I looked at OnError event in TOraSession class but i don't know how to get the last sql query.

Support team said me :

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

Hi,

I use NonBlocking option (true) to prevent blocking update by another user.

After my timeout (WaitExecuting) i call BreakExec. The problem is when i want to free my objet. The instruction wait for until the other who lock the record commit. Can you tell me what can i do?

My example :


pOraSQL->NonBlocking = true;
pOraSQL->Execute();

pOraSQL->WaitExecuting(5);

if(pOraSQL->Executing())
{
pOraSQL->BreakExec();
delete pOraSQL; //lock until transaction no committed by the other user.
throw Exception("LOCK");
}

The problem appear only when i update a record witch include a blob field (with a not null value)

Thank's a lot.

Can you tell me if it's possible to retrieve primary key (generated by a trigger before insert) after my insert?

I set ParamType to Db::ptOutput. The retrieve value is empty : pOraSQL->ParamByName("ID")->AsString.

Can you help me?

Hi,

Is it possible to work with the same session form two différente application.

My first application open a session with userName=USER1 password=PASS1 and servername=DATABASE1

My second application must connect to the database with the same connectstring as the first application but i don't want to creation a new session. So, is it possible to link the session of the second application to the first application?

Thank for your help.

I never call ApplyUpdates method from my application.

if i declare in my class (that derive from TOraSession) :

void __fastcall TMyOraSession::ApplyUpdates(TCustomDADataSet* const * DataSets, const int DataSets_Size)
{

}

The project compile.
Why there's this difference between ODAC5 and ODAC6 ?

Hello,

Since i updated ODAC (5.80.0.42 to 6.70.0.45) i can't link my c++ project.
My IDE is Borland C++ builder 5.

The message is :

[Lieur Erreur] Unresolved external '__fastcall Dbaccess::TCustomDAConnection::ApplyUpdates(Dbaccess::TCustomDADataSet * const *, const int)'

The problem comes from a class derivating from TOraSession.
This class, that i created in past, compile with ODAC.5

Can you help me please?

Thank you for your reply.