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

4 Comments

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


    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. Hi Uli

    Many thanks for the reply.

     

    We managed to solve the problem.

     

    It turns out that the application I'm working on refers to udesc.urr files in two separate locations. One is on a network drive - which the Uniface client assignment file points to - and the other on the Unix server which the urouter assignment file points to. I had only made my new signature available in the network file.

     

    Thanks again for taking time to respond.

     

    Regards

     

    David Hughes

     

     

     


    Author: drh76 (david.hughes@telecom.co.nz)
  3. Hi David,

    thanks a lot for this final "problem cause found and resolved" description;

    helpful for others like me to know the "best practises" when in a scenario like this.

    Success, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
  4. Hi David,

    Did you set up your $SSP path in your assignment file correctly.

    You must explicitly map the $SSP path, because it has no default mapping.

    did you have the proper license option to activate stored proc's?

    Regards,

    Arno


    Author: Arno Bonke (arno.bonke@uniface.com)