Trouble saving BLOB data using TORATable
Posted: 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
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