PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
sis01
Posts: 9
Joined: Thu 07 Mar 2013 16:43

PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Post by sis01 » Mon 27 Oct 2014 19:36

Hi all.

Im trying to debug a simple procedure inside a package.

First, i compliled the package for debugging, (whithout errors).

Then, When i try to Step-Into in any procedure get the message:
PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

What is it?

Thanks in advance

alexa

Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Post by alexa » Tue 28 Oct 2014 12:33

Could you please provide us the following information:

1. CREATE definition of the stored procedure.
2. Version of Windows operating system. Is it of x32 or x64?
3. Version of the Oracle client (if applicable). Is it of x32 or x64?
4. Version of the Oracle server. Is it of x32 or x64?

You can send a reply straight to our support system at supportATdevartDOTcom

sis01
Posts: 9
Joined: Thu 07 Mar 2013 16:43

Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Post by sis01 » Wed 29 Oct 2014 16:37

1. CREATE definition of the stored procedure.

CREATE OR REPLACE PACKAGE BODY MULTIFOX.PAQ_MULTIFOX AS
PROCEDURE REVISA_CRED IS
BEGIN
UPDATE /*+BYPASS_UJVC*/
(
SELECT PRN.CDGNS, PRN.CICLO, PRN.CANTAUTOR, MPD.NF
FROM MULTIFOX.MPD MPD,
SIACOM.PRN PRN
WHERE MPD.CDGNS = PRN.CDGNS AND MPD.CICLO = PRN.CICLO
AND PRN.CANTAUTOR > 0
) SET NF = null;
COMMIT;

END;
END PAQ_MULTIFOX;



2. Version of Windows operating system. Is it of x32 or x64?
Windows Server 2003 R1 - x32

3. Version of the Oracle client (if applicable). Is it of x32 or x64?
There is no oracle client, (dbforge dont need it)

4. Version of the Oracle server. Is it of x32 or x64?
ORACLE 8.0.5 x32

alexa

Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Post by alexa » Fri 31 Oct 2014 12:19

We suspect the issue lies in the DBMS_DEBUG package.

Post Reply