ORA-24323 [message #169836] |
Sat, 29 April 2006 03:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shashikoor
Messages: 25 Registered: April 2006 Location: india
|
Junior Member |
|
|
hai,
i've a problem in reports 6i (database oracle 9.2.1.0).
problem is that sometimes report runs successfully. but sometimes it says 'ORA-24323 value not allowed'. when i reconnect its running succesfuly sometimes. sometimes even reconnecting to the database is also not working.
i checked and found that i am passing values to all the mandatory parameters.
can any body please help me.
thanks in advance.
|
|
|
Re: ORA-24323 [message #169843 is a reply to message #169836] |
Sat, 29 April 2006 05:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It means tnat a null or invalid value was passed in for a mandatory parameter. Therefore, check that all mandatory parameters are properly initialized.
Null value is self-explanatory, but "valid value" could be, for example, the situation in which parameter is NUMBER and sometimes you pass numeric values to it (0, 1, 2, ..., 9) and sometimes character (A, B, ...) becuase you run out of possible numbers for that database column (declared as VARCHAR2(1) but populated with numbers 0, 1, ... 9. When you needed another one, you entered A, B, etc. which was OK for the database, but wrong as an input parameter.
|
|
|