empty blob error

[mhajduk]

on oracle query, if you have a table with 4 blob fields and you insert a record using the insert command with empty_blob() as the value for each blob and using the return function, oracle returns the error "blob can not be empty". This only happens on a table with more that 3 blob fields and only in 10g, it works fine in 8i. Is this an oracle problem or DOA problem.

if you leave out the 4th blob in the insert command then it works fine in 10g. Any ideas as to what may be the problem

 

[Marco Kalter]

Can you let me know the exact error message? Any ORA-nnnnn number?

 

[mhajduk]

the error message is as follows:

LOB variable :BULKYEFFECTS cannot be nil

there is not error number and if provided when the the query execute statement is executed and only if we use 4 lob variables.

 

[Marco Kalter]

This indicates that you have not assigned a TLOBLocator instance to the BULKYEFFECTS variable:

MyQuery.SetComplexVariable('BULKYEFFECTS', MyLOBLocatorInstance);

 

[mhajduk]

The problem is that the program does setComplexVariable. The program works with oracle 8i but not with 10g. It is the same code with the same oracle tables during our tests. Could it be a problem in the setcomplexvariable.

 

[Marco Kalter]

Direct Oracle Access does not treat 8i and 10g differently, so I can't imagine how this would be a problem in SetComplexVariable.