Explaining DOA behaviour

[Laurent Boutet]

Hi,
I'm french, so please forgive my french accent ;-)
I'm a beginner in Oracle...I'm migrating my project from Interbase 6 to Oracle 8.
And I use DOA...
Could you please explain me the behaviour of
DOA concerning CLOB. Indeed, I do manage using DOA with CLOB for inserting for instance...but I find it strange...you know...you must first declare a TLobLocator, then SetComplexVariable...then execute the query...and then you can put your data into the TLobLocator and finally commit...
(Till then, am I wrong ???)
I find this sequence of actions very strange...why wouldn't it be possible to set the complex variable to the correct data before executing ??

could you explain me some reasons ???

It may be a silly question...but please...

thanks in advance,
Laurent

 

[Marco Kalter]

This is the way it works in Net8. You have to obtain a LOb Locator and write the data through a stream interface. The TOracleDataSet can handle this for you through standard TBLOBFields.

------------------
Marco Kalter
Allround Automations