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
PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared
Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared
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
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
Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared
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
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
Re: PLS-00302 Component 'ABORT_ON_TIMEOUT' must be declared
We suspect the issue lies in the DBMS_DEBUG package.