Moving the content of a TBlobField to variable

[sveinn]

Environment; Delphi 6 and DOA 3.4.6

I

 

[Marco Kalter]

What exactly is the SQL text that is being used? Can you also confirm that this 'LONG_RAW_VALUE' variable is of type otLongRaw?

Note that you only need to use OnApplyUpdates in special situations. If you are converting from a TTable implementation, this should not be necessary!

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

 

[sveinn]

Hi Marco, and thanks for the reply.

The OracleDataset1.SQL contains a call to a procedure returning a multiple field cursor where one of the field is the 'LONG_RAW_FIELD'. The field is defined as a 'LONG RAW' in an Oracle table.

I don't attempt any translation of the field in Delphi. I don't read the fields into the fields-editor. However if I do, it gets translated into a TBlobField. But as I said, I don't do that.

I'm simply working with a field-name in a cursor witch is of the original type from the source table (I expect).

If I move something into the field with this method;
TBlobField(OracleDatase1.FieldByName('LONG_RAW_FIELD

 

[Marco Kalter]

Okay, if I'm not mistaken then the LONG RAW is a parameter, and therefore a PL/SQL variable:

LONG_RAW_FIELD owner.table%TYPE

PL/SQL variables are limited to 32KB. Could it be that your LONG RAW variable contains more data?

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

 

[sveinn]

Thanks for the promt reply Marco.
Yes, the problem is the 32KB size limit of the PL/SQL parameter, witch didn't know about. Knowing the problem, I made a workaround. Thanks again.
Sveinn.