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
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
-SK-
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:https://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.