Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06540: PL/SQL: compilation error

Re: ORA-06540: PL/SQL: compilation error

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Feb 2006 15:08:12 -0800
Message-ID: <1139440085.154735@jetspin.drizzle.com>


f.fioraso_at_gmail.com wrote:
> Hy,
> i have a problem with a function table. This function have a loop on a
> cursor, and create a "recordset". It work fine with the first 2 record,
> on the 3rd it send me ORA-06540 error.
> Why??
> I compile this function without errors!!
>
> Thanks.
> Bye

And you'd like us to guess are your Oracle version and guess at the code and guess at the DDL for any objects it references.

You know I would except I have other stuff to do this afternoon.

If you aren't charged by the character to post here you might want to ask again and this time think through what might be required to help you.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Feb 08 2006 - 17:08:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US