Hi all,
I have an apex page item P2_REQ_NO, on change of it i'm passing the value to interactive grid query.
select * from REQUEST_DATA where REQ_NO = v('P2_REQ_NO')
But it is throwing "Ajax call returned server error ORA-01722: invalid number for .".
The same functionality is working perfectly in different environment. I tried converting both parameters to TO_CHAR but still the error is coming.
Kindly need your help in resolving this issue.