Re: ORA-24323

There were changes in some parameter specifications between 7.1 and 7.3 and following so that a parameter that could be "" in 7.1 now has to be NULL - Check for any triggers, etc that may have the "" and replace it with NULL --

I know this was the case with Forms and I suspect it applies to reports as well...

Hope it helps,

"Paul A. Deibel" <deibel_at_ici.net> wrote:

>Hello everyone:
>
> I am running Oracle 8.0 D/B Reports 6.0
>I am trying to convert a report which worked
>perfectly under Oracle 7.1 Reports 2.5
>I get an ORA-24323 message "value not allowed."
>The report will not run.
>
>The queries, if cut and paste to SQLPLUS 8
>work perfectly.
>
>The error documentation talks about a null or
>bogus parameter value, but this does not seem
>to be the case.
>
>Is anyone else struggling with this? Any
>ideas on what to look for?
>
>Thanks,
>
>Paul Deibel,
>
>deibel_at_ici.net

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Aug 16 1999 - 17:38:55 CEST