Oracle Multimedia Invalid PLS-00539: subprogram 'GET_GTYPE' PLS-00538: GET_GTYPE , GET_DIMS,GET_LRS_DIM is declared in an object type specification and must be defined in the object type body (Doc ID 2596940.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Oracle Multimedia (ORDIM) is INVALID.

runing  @$ORACLE_HOME/md/admin/sdogmmb.plb

getting same below error .

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/20     PLS-00539: subprogram 'GET_GTYPE' is declared in an object type
        body and must be defined in the object type specification

7/29     PLS-00538: subprogram or cursor 'GET_GTYPE' is declared in an
        object type specification and must be defined in the object type
        body

9/29     PLS-00538: subprogram or cursor 'GET_DIMS' is declared in an
        object type specification and must be defined in the object type
        body


LINE/COL ERROR
-------- -----------------------------------------------------------------
10/20    PLS-00539: subprogram 'GET_DIMS' is declared in an object type
        body and must be defined in the object type specification

11/29    PLS-00538: subprogram or cursor 'GET_LRS_DIM' is declared in an
        object type specification and must be defined in the object type
        body

18/20    PLS-00539: subprogram 'GET_LRS_DIM' is declared in an object type
        body and must be defined in the object type specification

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.