SQL & PL/SQL :: SP Executes Fine In One Server But Not In Another One

I have some trouble with a stored procedure I've created, when I run it in the server dedicated to developers it runs fine, and updates 100,000 record in 23 seconds, but when I run it in the production server it collapses and don't update anything. Here's my code.

CREATE OR REPLACE PROCEDURE cdc_sp_comp_tablas_paudit IS

TYPE t_folio_log IS TABLE OF cdc_compara_consulta_paudit.nconencfolio%TYPE;
v_folio_log t_folio_log;

CURSOR c_folios_bd IS
SELECT a.nconencfolio
FROM cdc_compara_consulta_paudit a
, cdc_consulta_encabezado b
WHERE a.nconencfolio = b.nconencfolio
[code].......

I'm using Oracle 9g,