Re: PLS-707 error?

Once i get that error on the execution of an old procedure that always worked well. Status of the procedure was VALID.

I just recompiled it and all was OK!

I never was able to reproduce the problem.

--
Regards
Michel

Yass Khogaly <ykhogaly_at_us.oracle.com> a écrit dans le message : 823ehm$272$1_at_inet16.us.oracle.com...
> ext: unsupported construct or internal error [%s]
> --------------------------------------------------------------------------
> -
> Cause: If this error occurs during compilation:
>
> (1) It can indicate that an remote-procedure call is being
> compiled to a remote program with a parameter-type or parameter
> default-value
> expression that is not supported at the calling site.
>
> (2) Or it can occur when an incomplete upgrade or downgrade has
> been made to a database with stored procedures, i.e., the upgrade or
> downgrade may require particular versions of system packages
> (e.g., STANDARD.SQL, DBMSSTDX.SQL, etc.) to be installed, and
> this error may occur if the incorrect versions of those
> packages are installed.
>
> (3) In some cases, a compiler bug will be reported through this
> error message. In such cases, legal PL/SQL syntax fails to compile, and
> this
> error message is given instead.
>
>
> If this error happens during execution:
>
> (4) This message could also be generated during PL/SQL execution
> in which case it could be a real internal error.
>
> Action: The following are actions for dealing with the above issues:
>
> (1) RPC is not supported to a remote program with a type or
> default-value that is not supported at the local site. The programmer must
> change the logic of the application to use parameter-types and
> expressions that are supported at both sites.
>
> (2) If you get this error on an incomplete upgrade or downgrade,
> it should remind you to complete the upgrade or downgrade process.
>
> (3) Please report to Oracle any errors on legal PL/SQL syntax. If
> the line and column numbers displayed with the error message are non-
> zero, they may help you to find a workaround for the bug until
> a fix is available.
>
> For example, you may be able to recode that line to avoid the
> bug. (If the line and column are zero, then the compiler cannot report
> on which line of your program the error occurred.)
>
> (4) Report the internal error to your Support Rep.
>
> "The Views expressed here are my own and not necessarily those of Oracle
> Corporation"
>
> Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid> wrote in message
> news:1761dd4a.83218a5c_at_usw-ex0101-008.remarq.com...
> > Using Oracle 8.0.5 on NT
> >
> > I wrote a function and an anonymous block to capture and display the
> > function result.
> >
> > The function compiles fine and executes fine (within the stored block)
> > if I'm connected as the user who created the function.
> >
> > I grant execute to another user.
> >
> > When I try to run the anonymous block as another user (either one with
> > privileges, or even system) I get a PLS-707 Unsupported construct, or
> > internal error (2601). I get the same error if I try to call the
> > function from Delphi.
> >
> > I have a tar with Oracle support and have looked at the metalink
> > documentation and can't seem to get resolution.
> >
> > Does anybody have any thoughts?
> >
> > -greg
> >
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
> *
> > The fastest and easiest way to search and participate in Usenet - Free!
> >
>
>
Received on Wed Dec 01 1999 - 10:48:33 CST