ERROR IN REGORD GROUP CREATING ORA-01007

From: (wrong string) ä <markku.heikkila_at_ccc.fi>
Date: Fri, 21 Aug 1998 06:33:11 GMT
Message-ID: <6rj492$lln$1_at_news.kolumbus.fi>

I have procedure wich populate tlist from recordgroup. Code is below. Occasionally I get ORA-01007 error from rdbms. Is this due the rdbms version or something like that????

RDBMS version is 7.2.3.0.0 and pl/sql version is 2.2.3.0.0

PROCEDURE getusers IS
  cotsikko2 varchar2(50);
  cotsikko varchar2(20);
  rg_name VARCHAR2(14) := 'rg_goal';
  rg_id RecordGroup;
  errcode NUMBER;
  the_rowcount NUMBER;
begin
  rg_id := Find_Group( rg_name );
  if Id_Null(rg_id) THEN

        rg_id := Create_Group_From_Query( rg_name, 
         'select rpad(substr(lastname,1,15)||'' ''||  
substr(forename,1,15),31)||to_char(person_id),'            


        ||'to_char(person_id)'            

        ||' FROM PT_TTL_USERS' 

        ||' WHERE SUBSTR(DEPT_ID,1,2) = :user.dept' 

        ||' AND IS_ID_CURRENT=1'


        ||' order by lastname, forename'); 


        errcode := Populate_Group( rg_id ); 
  else
        delete_group_row(rg_id,ALL_ROWS);
        errcode := Populate_Group_With_Query( rg_id, 
         'select rpad(substr(lastname,1,15)||'' ''||  
substr(forename,1,15),31)||to_char(person_id),'            


        ||'to_char(person_id)'            

        ||' FROM PT_TTL_USERS' 

        ||' WHERE SUBSTR(DEPT_ID,1,2) = :user.dept' 

        ||' AND IS_ID_CURRENT=1'


        ||' order by lastname, forename'); 


        errcode := Populate_Group( rg_id ); 

  END IF; ........    

END; PS: It seems that when there are multiple users this error happens more often, but I Ain't sure

I NEED HELP WITH THIS ONE FELLOWS Greetings from Finland
Markku Heikkilä Received on Fri Aug 21 1998 - 08:33:11 CEST