ORA-01460 error only in production enviorment in ADF 11g application
Hi ,
We are using ADF 11g rel 1 11.1.1.4.0
And database is
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
All our enviornments are running the same database
But when we are deploying the application in Production we get the Error
JBO-27122: SQL-fejl under forberedelse af sætning. Sætning:
select DB_TST_API.test_proc(Id1, id2) from table;
.
.
.
## Detail 0 ##
java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
.
.
While executing the query which has a call tp API and input variable
select DB_TST_API.test_proc(Id1, id2) from table;
The DB function is defined as
the FUNCTION test_proc(p_value IN VARCHAR2, p_list IN VARCHAR2) RETURN number;
The input parameter is only 10 digit integer in ADF application, there is a logical difference that the DB function takes a string and ADF is supplying with Integer, but the code has worked before and has suddenly started giving this error
The code also works fine on all other test eviornments
Also the sql query when run from sql devleoper on production DB does not give any error
Its becoming difficult to find out what could be causing this only on production enviornment