 ORA-24323 [message #169836] |
Sat, 29 April 2006 03:21  |
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  |
 |
Littlefoot
Messages: 21811
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
