mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

ORA 24816 - Saving Record

Hi AB Posting a TSQLRecord containing a BLOB (RawUtf8 without Index) we get the Error ORA 24816
we use TSQLDBZEOSConnectionProperties with dOracle

"ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column"

Using the Rest Interface.

The Query mORMot generates is a standard SQL Query

insert into xxx (blobfield) values ('<500 Char String>')

If i defined

TSQLRecord
..
blobfield : RawUtf8;
..

if i modify with

blobfield : RawUtf8 index 500;

Everything works fine.
ATM this "workaround" is ok for me my field is smaller than 500 char.

Is there a better solution ?

Last edited by itSDS (2017-05-31 10:23:47)

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,237

Website

Re: ORA 24816 - Saving Record

BLOB are expected to be not RawUTF8, but TSQLRawBlob properties.

CLOB should have been created as such in the table.

How was your table created?