Home » Developer & Programmer » Reports & Discoverer » ORA-24323 Value not allowed in the Report Builder
ORA-24323 Value not allowed in the Report Builder [message #138179] Tue, 20 September 2005 10:43 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Arabic Language not show in oracle reports 11G
Next Topic: Scatter Chart
Goto Forum:
  


Current Time: Thu Mar 28 17:53:12 CDT 2024