Re: ORA-24323

From: TurkBear <>
Date: Mon, 16 Aug 1999 15:38:55 GMT
Message-ID: <>

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" <> 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?
>Paul Deibel,

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- 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

Original text of this message