Trouble saving BLOB data using TORATable

h.hasenack · Post by **h.hasenack** » Mon 30 Mar 2009 09:02

Copied this from the debug window (clearing image blob field)

UPDATE WBOBJDAT
SET
IMAGE=NULL, MODIF = :MODIF
WHERE
ID = :Old_ID
RETURNING
IMAGE
INTO
:IMAGE

Here's the error:
ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

Maybe the returning type isn't correct?

regards - hans

h.hasenack · Post by **h.hasenack** » Thu 02 Apr 2009 06:15

Fixed.

Turned out my internal field was a tBlobField. Using the oracle fielddefs (TOraBlobfield) fixed the issue.