Entity Framework 5.0: Update table with a clob field by Lightswitch

782704 Apr 19, 2013 9:14 AM

Hello,

I use MS Lightswitch 2012 with Entity Framework 5.0 and Oracle ODAC 11.2 Release 5 and Oracle Developer Tools for Visual Studio (11.2.0.3.20) in Visual Studio Ultimate 2012.

if i update a record of a table with a clob column. i get the error message "ORA-00932: inconsistent datatypes: expected - got CLOB".

I think, the internal used where clause ... and clob_field <> '.....' is the reason for this error.

What can I do, to get no error?

Frank

1. Re: Entity Framework 5.0: Update table with a clob field by Lightswitch

user1675994 Jul 19, 2013 10:29 AM (in response to 782704)

We have the same problem. Using both ODAC and ODP Managed Beta gives the same error.

You can save text to a CLOB the first time, but any subsequent updates gives this error

We are using the Lightswitch HTML Client.
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.