Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Create a Oracle Job

Can anyone can help me on this . me wanna create following this as a job.. can anyone can create a package for dat...

declare
begin

pk_ac_t_balance.UPDATE_GLBAL('RA00','2006','1');
pk_ac_t_balance.update_glbal('RA00','2006','2');
pk_ac_t_balance.update_glbal('RA00','2006','3');
pk_ac_t_balance.update_glbal('RA00','2006','4');
pk_ac_t_balance.update_glbal('RA00','2006','5');
pk_ac_t_balance.update_glbal('RA00','2006','6');
pk_ac_t_balance.update_glbal('RA00','2006','7');
pk_ac_t_balance.update_glbal('RA00','2006','8');
pk_ac_t_balance.update_glbal('RA00','2006','9');
pk_ac_t_balance.update_glbal('RA00','2006','10');
pk_ac_t_balance.update_glbal('RA00','2006','11');
pk_ac_t_balance.update_glbal('RA00','2006','12');

pk_ac_t_balance.update_glbal('BL00','2006','1');
pk_ac_t_balance.update_glbal('BL00','2006','2');
pk_ac_t_balance.update_glbal('BL00','2006','3');
pk_ac_t_balance.update_glbal('BL00','2006','4');
pk_ac_t_balance.update_glbal('BL00','2006','5');
pk_ac_t_balance.update_glbal('BL00','2006','6');
pk_ac_t_balance.update_glbal('BL00','2006','7');
pk_ac_t_balance.update_glbal('BL00','2006','8');
pk_ac_t_balance.update_glbal('BL00','2006','9');
pk_ac_t_balance.update_glbal('BL00','2006','10');
pk_ac_t_balance.update_glbal('BL00','2006','11');
pk_ac_t_balance.update_glbal('BL00','2006','12');

pk_ac_t_balance.update_glbal('EM00','2006','1');
pk_ac_t_balance.update_glbal('EM00','2006','2');
pk_ac_t_balance.update_glbal('EM00','2006','3');
pk_ac_t_balance.update_glbal('EM00','2006','4');
pk_ac_t_balance.update_glbal('EM00','2006','5');
pk_ac_t_balance.update_glbal('EM00','2006','6');
pk_ac_t_balance.update_glbal('EM00','2006','7');
pk_ac_t_balance.update_glbal('EM00','2006','8');
pk_ac_t_balance.update_glbal('EM00','2006','9');
pk_ac_t_balance.update_glbal('EM00','2006','10');
pk_ac_t_balance.update_glbal('EM00','2006','11');
pk_ac_t_balance.update_glbal('EM00','2006','12');

pk_ac_t_balance.update_glbal('KW00','2006','1');
pk_ac_t_balance.update_glbal('KW00','2006','2');
pk_ac_t_balance.update_glbal('KW00','2006','3');
pk_ac_t_balance.update_glbal('KW00','2006','4');
pk_ac_t_balance.update_glbal('KW00','2006','5');
pk_ac_t_balance.update_glbal('KW00','2006','6');
pk_ac_t_balance.update_glbal('KW00','2006','7');
pk_ac_t_balance.update_glbal('KW00','2006','8');
pk_ac_t_balance.update_glbal('KW00','2006','9');
pk_ac_t_balance.update_glbal('KW00','2006','10');
pk_ac_t_balance.update_glbal('KW00','2006','11');
pk_ac_t_balance.update_glbal('KW00','2006','12');

end;

thankzzzzz
lahiru

lahiru27@gmail.com
[4269 byte] By [lahiru27] at [2007-11-11 10:07:20]