UACTERR_OBJECT_DELETED

Author: david.hughes@telecom.co.nz (drh76)

Hello



I'm working with Uniface 8.4.02 and ORACLE 9i.



I am attempting to call an ORACLE stroed procedure using 'ACTIVATE' in a form



The stored procedure definition in the DB is :



CREATE OR REPLACE PACKAGE DRH_TEMP_PACKAGE AS


PROCEDURE DRH_INSERT ( P_CAPABILITY_ID IN NUMBER , P_RETURN OUT NUMBER, P_RETURN_MSG OUT VARCHAR2 ) ;


END DRH_TEMP_PACKAGE;


/


I have created a signature for this in Uniface, compiled and exported this to both the uana.urr and udesc.urr runtime repository files.



When I run the form . . .



variables


numeric return_status


string return_msg


endvariables



activate "DRH_TEMP_PACKAGE".DRH_INSERT(999,return_status,return_msg )


if ($status < 0)


putmess "The status is : %%$status%%% and the procerror is %%$procerror%%% / %%$procerrorcontext%%%"


putmess "%%$formname : Error executing Oracle Procedure DRH_TEMP_PACKAGE.DRH_INSERT %%return_msg"


endif



. . . this error appears in the output log:



Descriptor for DRH_TEMP_PACKAGE found in usys:uana.urr


The status is : -88 and the procerror is -88 / ERROR=-88MNEM=<UACTERR_OBJECT_DELETED>DESCRIPTION=Object has been deleted earlierCOMPONENT=Z1005PROCNAME=ACPTTRIGGER=ACPTLINE=5ADDITIONAL=INSTANCENAME=DRH_TEMP_PACKAGEOPERATIONNAME=DRH_INSERT



I have searched this and other forums and even resorted to reading the Uniface documentation but have found no reference to the 'Object deleted earlier' error.



Other calls to ORACLE stored procedures are working correctly in the application so I'm assuming I'm doing something wrong with the deployment of the signature.



Any help most gratefully received