Oracle Database Discussions

Hi everyone,

One of our hosted server is experience this error:
[ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
State:NA000,Native:24816,Origin:[Microsoft][ODBC driver for Oracle][Oracle]

When trying to insert/update some data using the hosted application's utility. The data does consist of text (lots of them really). But same application has been used over long time now and we have never seen this error in past.
Ironically, this does not happen with our other Oracle servers or MS-SQL servers when inserting the same data using the same application functionality.

I have Googled and Googled for this but this is all I am able to fetch is:
Cause
A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG
Not sure too sure what this means.

Action
Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.
Not sure of this one either. Surely, the application does run a SQL, but theres no way I can really change it before it is executed surely?
Error is clearly coming from Oracle. Strangely this works on other Oracle servers. Now I am at a loss and unable to determine what settings can I compare or look at to determine the cause of the issue.

A gut feeling says, this might be because of some charaterset settings?

Can some one suggest where could this be steaming from.

Any help is appreciated. Thanks. N