Page 1 of 1

Trouble saving BLOB data using TORATable

Posted: Mon 30 Mar 2009 09:02
by h.hasenack
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

Posted: Thu 02 Apr 2009 06:15
by h.hasenack
Fixed.

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