PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared

Postby 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
sis01
 
Posts: 9
Joined: Thu 07 Mar 2013 16:43

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

Postby 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
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

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

Postby 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
sis01
 
Posts: 9
Joined: Thu 07 Mar 2013 16:43

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

Postby alexa » Fri 31 Oct 2014 12:19

We suspect the issue lies in the DBMS_DEBUG package.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle