Home » Developer & Programmer » Reports & Discoverer » ORA-24323
- icon8.gif  ORA-24323 [message #169836] Sat, 29 April 2006 03:21 Go to next message
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.

Report message to a moderator

- Re: ORA-24323 [message #169843 is a reply to message #169836] Sat, 29 April 2006 05:15 Go to previous message
Littlefoot
Messages: 21825
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.

Report message to a moderator

Previous Topic: Printing Continue on Next page number
Next Topic: using matrix in my reprort
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 16 03:50:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.