Home » SQL & PL/SQL » Client Tools » Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column (merged 2)
Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column (merged 2) [message #664014] Mon, 03 July 2017 07:23 Go to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member
Hi

I am getting below error message while inserting the data.

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


Please help me on this issue.


Thanks

Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664015 is a reply to message #664014] Mon, 03 July 2017 07:27 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

what OS name & version?
Which Oracle version to 4 decimal places?

we can't debug code we can not see.
When was last time it worked without error?
what changed since then?
Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664016 is a reply to message #664014] Mon, 03 July 2017 07:50 Go to previous messageGo to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member
Hi

I am trying to insert the data from one database to another database through AbInitio ETL Tool.

Source table is having 5 fields with 4000 charter of data type VARCHAR,where as in the destination table relevant field data type is CLOB.

In Abinitio we are concatenating 5 fields into one string and loading into CLOB field


I am getting below error message while loading the data through AbInitio ETL tool.

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


Please help me on this issue.


Thanks
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664017 is a reply to message #664016] Mon, 03 July 2017 07:53 Go to previous messageGo to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All

Sorry for two many postings :

Oracle Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664018 is a reply to message #664017] Mon, 03 July 2017 08:10 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
[oracle@vbgeneric ~]$ oerr  ora 24816
24816, 00000, "Expanded non LONG bind data supplied after actual LONG or LOB column"
// *Cause:  A Bind value of length potentially > 4000 bytes follows binding for
//          LOB or LONG.
// *Action: Re-order the binds so that the LONG bind or LOB binds are all
//          at the end of the bind list.
[oracle@vbgeneric ~]$ 
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664036 is a reply to message #664018] Tue, 04 July 2017 00:54 Go to previous messageGo to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member
Hi Blackswan ,

Thanks for your replay.
But we are not passing any bind variables to this program
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664038 is a reply to message #664036] Tue, 04 July 2017 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So don't you think it is important to tell us in details what you did when you got this error?

Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664089 is a reply to message #664036] Tue, 04 July 2017 08:25 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
saipradyumn wrote on Mon, 03 July 2017 22:54
Hi Blackswan ,

Thanks for your replay.
But we are not passing any bind variables to this program
Oracle disagrees with you & I know that Oracle reports reality better than you.

You have a mystery & we have no clues.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664340 is a reply to message #664089] Wed, 12 July 2017 06:37 Go to previous messageGo to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member

Hi BlackSwan/Michel

I don't have much information on this problem

Thanks
SaiPradyumn

Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664342 is a reply to message #664340] Wed, 12 July 2017 06:40 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
how can we reproduce what you report?
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664343 is a reply to message #664342] Wed, 12 July 2017 07:25 Go to previous messageGo to next message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member
Hi BlackSWan ,

Without changing any code,data it went fine in production .
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664345 is a reply to message #664343] Wed, 12 July 2017 07:44 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
When you observe different results, then you can safely & assuredly conclude that something is different.
Since we do not have access to either database, where it runs without error & where error get thrown, only you can compare & contrast the 2 DBs.
Either you will learn what is different or you live with the status quo.
Re: Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column [message #664347 is a reply to message #664345] Wed, 12 July 2017 07:51 Go to previous message
saipradyumn
Messages: 303
Registered: October 2011
Location: Hyderabad
Senior Member

Hi BlackSwan,

will try to do the same when ever we have problem in production.

thanks for your support and guidance .
Previous Topic: sqlpptool SQL logging
Next Topic: SQL spool file, line gets cutoff at 80 characters
Goto Forum:
  


Current Time: Fri Nov 24 23:22:23 CST 2017

Total time taken to generate the page: 0.01308 seconds