Author: firstname.lastname@example.org (drh76)
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 ) ;
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 . . .
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"
. . . 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