My Oracle Support Banner

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 APRIL 24, 2020

Applies to:

Oracle Multimedia - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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