ORA - 6502 (numeric or value error string) , FRM - 40735 [message #579681] |
Thu, 14 March 2013 01:13 |
|
new_oracle2011
Messages: 174 Registered: March 2011 Location: Qatar
|
Senior Member |
|
|
I have made a report with sql injection. there is no problem with the report. but when i run from the form with following string it gives error.
:global.where_clause := 'where request_type = 5 and request_status in (3, 4, 5) and list_approval_date is null';
And no error is there if i passed the string as
:global.where_clause := 'where request_status in (3, 4, 5) and list_approval_date is null';
REQUEST_TYPE is a database column and it is of number type. Can somebody help me how to solve this problem?
|
|
|
|
|
|
|
|
|
|
|
|