Help with ORA-00002 Error Message

From: Vijaya Masina <vmasina_at_erac.com>
Date: Fri, 15 Mar 2002 16:26:12 GMT
Message-ID: <Egpk8.11827$Ml3.2816876727@newssvr11.news.prodigy.com>

Hello,

    I have recieved ORA-00002 in executing a INSERT statement using the RETURNING clause.I am not able to find information in Oracle documentation .

    Has anyone an idea why I get this error ?

Proc Code:

   EXEC SQL

        INSERT INTO obj_typ
                   (SEC_OBJ_TYP_ID,
                    SEC_OBJ_TYP_NAM,
                    SEC_OBJ_DSC,
                    UPDATED_BY,
                    UPDATE_TIMESTAMP)
        VALUES (
                    obj_typ_seq.NEXTVAL,


                    :h_szObjName    INDICATOR :h_szObjName_i,

                    :h_szObjDesc    INDICATOR :h_szObjDesc_i,

                    :h_szUpdatedBy  INDICATOR :h_szUpdatedBy_i,

                    SYSDATE)

  RETURNING SEC_OBJ_TYP_ID INTO :h_lTypeID;

Thanks for help!

Vj Received on Fri Mar 15 2002 - 10:26:12 CST