error during external solution publish ORA-01461 can bind a long only for insert into

Hello Everyone,

While publishing system component getting below error 

"error during external solution publish ORA-01461 can bind a long only for insert into a long column" 

 Can anyone please help me out.



Regards

Shashi Kant Shukla

Hello Shashi Kant Shukla,


Can you try to change the column type to a CLOB instead of a long or possible VARCHAR/VARCHAR2 ?
This can solve the issue according to:
http://www.dba-oracle.com/t_ora_01461_can_bind_a_long_value_only_for_insert_into_a_long_column.htm and
https://stackoverflow.com/questions/9156019/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column-occurs-when


Kind regards,


Michael de Ruijter

Hi Michael,

I dont know the table name where I can change VARCHAR/VARCHAR2  because I am getting this error while publishing system component I haven’t created any entity.


Can you please me know where I should made the changes.

Regards

-SK-


Solution

Hi,

I found the solution 

This is an  Oracle Data Provider for .NET (ODP.NET)Driver Issues 

This is link which is having solution

https://success.outsystems.com/Support/Enterprise_Customers/Troubleshooting/Oracle_Data_Provider_for_.NET_(ODP.NET)_Driver_Issues#Resolution


Regards

-SK-


Solution