ORA-24323 Value not allowed in the Report Builder [message #138179] |
Tue, 20 September 2005 10:43 |
pandeabh
Messages: 2 Registered: September 2005 Location: Mumbai
|
Junior Member |
|
|
Hi All,
I have one report which is running in the production instance, now i want to modify that report. But when i'm opening that report in the report buider of the deve instance with minute changes it throws an error ORA-24323 Value not allowed and it drops the connection to that instance.
If i run that same query with hard coded values instead of bind variables it is not giving any error. And if i replace any of that hard coded value with parameter then it throws this error.
Can anyone pls help me.
1. AND ai.org_id = NVL(ai.org_id,ai.org_id) -- will run successfully
2. AND ai.org_id = NVL(1485,ai.org_id) -- will run successfully
3. AND ai.org_id = NVL(:org_id,ai.org_id) -- will throw an error
Pls reply ASAP, thanks in advance
|
|
|