Trigger errors following upgrade from FC 10.0 to FC 10.1

[former_member628218]

Dear all,

The following error appears we try to save a package : image001.jpg

Below are the triggers called on ORA-04088 :

call bfcdev.CREATETRIGINSERT([PHASE],[UPDPER]);
call bfcdev.CREATETRIGDEL([PHASE],[UPDPER]);

Here is the code and the error on line 19 in BOLD.

declare

NbCode number;

NbIdentifier number;

NbOKFree integer;

NomEntite VARCHAR2(12);

NCodeAreaType number;

begin

select count(*) into NbCode from BFCDEV.ct_0000_ZONE where ldesc1=:new.data_comment;

select CT_0000_ISFREE into NbOKFree from BFCDEV.ct_0000_ZONE where id=:new.ct_0000_ZONE;

select name into NomEntite from BFCDEV.ct_entity where id=:new.entity;

if :new.accnt=1261 then

select id into NCodeAreaType from BFCDEV.ct_0000_areatype where name='LITIGE';

else

select id into NCodeAreaType from BFCDEV.ct_0000_areatype where name='NCURRENT';

end if;

if NbCode=0 and NbOKFree =-1 then

select LAST_OBJECT_ID +1 into NbIdentifier from =(select reftable from BFCDEV.ct_dimension where name='AREA');

insert into BFCDEV.ct_0000_ZONE (ID,NAME,SDESC1,SDESC2,LDESC1,LDESC2, CT_0000_ENTITY,CT_0000_AREATYPE,OWNER_SITE) values (NbIdentifier,BFCDEV.CodeNature(:new.entity),NomEntite,NomEntite,:new.data_comment,:new.data_comment,:new.entity,NCodeAreaType,-1);

update BFCDEV.ct_identifier_pool set LAST_OBJECT_ID=NbIdentifier where manager_id=(select reftable from BFCDEV.ct_dimension where name='AREA');

end if;

end;

Could anybody provide an explanation / solution to this matter?

Regards,

Julien

[Marc_Kuipers]

Hi Julien

Technically, the reason is that your temp table (Takoxt76on5og) has no data

See: http://www.dba-oracle.com/sf_ora_01403_no_data_found.htm

The T-table is normally the [worktable], i.e. the package itself. Could this be empty when you are saving?

Marc