OraFAQ Forum: Client Tools » Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column (merged 2)

Home » Other » Client Tools » Oracle Error: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column (merged 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

saipradyumn
Messages: 419
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

Report message to a moderator

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

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

saipradyumn
Messages: 419
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

Report message to a moderator

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

saipradyumn
Messages: 419
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

Report message to a moderator

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

BlackSwan
Messages: 26766
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 ~]$

Report message to a moderator

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

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi Blackswan ,

Thanks for your replay.
But we are not passing any bind variables to this program

Report message to a moderator

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

Michel Cadot
Messages: 68634
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?

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi BlackSwan/Michel

I don't have much information on this problem

Thanks
SaiPradyumn

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

how can we reproduce what you report?

Report message to a moderator

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

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi BlackSWan ,

Without changing any code,data it went fine in production .

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

saipradyumn
Messages: 419
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 .

Report message to a moderator

Previous Topic:	SQL spool file, line gets cutoff at 80 characters
Next Topic:	oracle configuration tools to be used for server database connection with client pc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 02:05:37 CDT 2024