Help Me~.

From: choi, sang soon <topgun_at_freeway.co.kr>
Date: Thu, 03 Sep 1998 15:29:50 +0900
Message-ID: <35EE375D.B21C3F5B@freeway.co.kr>

This Script is execute in PL/SQL

/*
select x.emp_id, x.name_k, o.orga_name_k, p.posi_g_name,

       x.branch_posi_day, x.last_promotion_day , promot.app_sday app_sday ,

       move.app_sday app_sday2, o.seq_code

from hr_hiba_t x, ho_orga_t o, hr_pogr_t p,

( select emp_id, max(app_sday) app_sday
from hr_apit_t
where app_code in ('202' , '204', '102','103') and

      app_sday < '19980901'

group by emp_id ) promot,

( select emp_id, max(app_sday) app_sday
from hr_apit_t
where ( ( app_code in ('302','109') and app_name_code in ( '10' ,'19') ) or

        app_code in ( '102','103') or
        ( app_code in ('202','204') and orga_code > '0' and orga_code <>
src_orga_code and
          app_name_code in ( '10' ,'19') ) ) and
       app_sday < '19980901'
group by emp_id ) move
where  x.emp_id = promot.emp_id (+) and
       x.emp_id = move.emp_id (+) and
       x.state_classify > 'N0' and
       x.src_orga_code = o.orga_code and
       x.src_posi_g_code = p.posi_g_code  and
       move.app_sday > '0'
       ;

*/

BUT Below Script is not execute and issue Oracle Error

/*
declare
  cursor c1 is
select x.emp_id, x.name_k, o.orga_name_k, p.posi_g_name,

       x.branch_posi_day, x.last_promotion_day , promot.app_sday app_sday ,

       move.app_sday app_sday2, o.seq_code

from hr_hiba_t x, ho_orga_t o, hr_pogr_t p,

( select emp_id, max(app_sday) app_sday
from hr_apit_t
where app_code in ('202' , '204', '102','103') and

      app_sday < '19980901'

group by emp_id ) promot,

( select emp_id, max(app_sday) app_sday
from hr_apit_t
where ( ( app_code in ('302','109') and app_name_code in ( '10' ,'19') ) or

        app_code in ( '102','103') or
        ( app_code in ('202','204') and orga_code > '0' and orga_code <>
src_orga_code and
          app_name_code in ( '10' ,'19') ) ) and
       app_sday < '19980901'
group by emp_id ) move
where  x.emp_id = promot.emp_id (+) and
       x.emp_id = move.emp_id (+) and
       x.state_classify > 'N0' and
       x.src_orga_code = o.orga_code and
       x.src_posi_g_code = p.posi_g_code  and
       move.app_sday > '0'
       ;

begin
  for c1r in c1 loop

     update hr_hiba_t
     set    branch_posi_day = c1r.app_sday2
     where  emp_id = c1r.emp_id ;

  end loop;
  commit work;
end;
/

Error Message

   ORA-01410: invalid ROWID
   ORA-06512: at line 3
   ORA-06512: at line 28

I want to Know the error and I'm Urgent..

Our System : Oracle 7.3,

                    Sun System

MiddleWare : SQL*Net

Please Send me a e-mail

 <Mailto:topgun_at_freeway.co.kr >

                    Thanks in Advanece.

                                                     Sincerely.

Received on Thu Sep 03 1998 - 01:29:50 CDT