Hi,
I'm struggling with clobs. We have a multitier application in D7. At the middleware-server we have the DOA-components. The client-application is connecting via TClientDataSet-object to the middleware. Everything is working find, till we needed clobs.
I would need to have a clob as input, do a select-statement and an amount of records will be returned. The TOracleDataSet has 1 variable of type CLOB. At clientside, the TCLientDataSet has 1 param set to type ftOraClob.
When I do "Params.ParamByName('structure').AsMemo := 'clob that is less then 4000 chars...';" it's working fine, but the moment I'm over 4000 chars only the first 4000 chars are send to oracle. I've tried loadFromStream etc. but nothing helped. A TLOBLocator can't be used because the client hasn't got a session-object.
Does anyone has experience with such a setup? Any solutions?
thanks in advance
I'm struggling with clobs. We have a multitier application in D7. At the middleware-server we have the DOA-components. The client-application is connecting via TClientDataSet-object to the middleware. Everything is working find, till we needed clobs.
I would need to have a clob as input, do a select-statement and an amount of records will be returned. The TOracleDataSet has 1 variable of type CLOB. At clientside, the TCLientDataSet has 1 param set to type ftOraClob.
When I do "Params.ParamByName('structure').AsMemo := 'clob that is less then 4000 chars...';" it's working fine, but the moment I'm over 4000 chars only the first 4000 chars are send to oracle. I've tried loadFromStream etc. but nothing helped. A TLOBLocator can't be used because the client hasn't got a session-object.
Does anyone has experience with such a setup? Any solutions?
thanks in advance
