UACTERR_OBJECT_DELETED

[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.

[ThomasY]

Hi,

i faced -88 mostly when i work with handle or string instance-variables.

especially you have a newinstance and call a operation which do a exit.
So the next activate is got the -88, because the object don't exists anymore.

Also if you use something like return (-1) in the INIT operation (constructor).

But I'm not sure what it is meant in your case. Maybe there are some missing privilegies.

HTH
Thomas

[Uli]

Hi David,

at first I recommend you add $dberror to your lits of informations;
it may give a more detailed info what the Oracle driver has encountered.

Because you have activated other StoredProcs in your application,
and you know how to create these signatures
I assume that this is problem with "GRANT" access to the StoredProc.

This runs +/- in line with the uniface error message which says
that the object could not be accessed

SUccess, Uli

[Uli]

Problem solved (see uniface.info).

The uniface server has URR and DOL as well which were not updated.