Updated on 2024-08-20 GMT+08:00

DBE_DESCRIBE

For details about the basic interfaces supported by DBE_DESCRIBE, see Table 1 DBE_DESCRIBE basic interfaces.

Table 1 DBE_DESCRIBE basic interfaces

Interface

Description

DBE_DESCRIBE.GET_PROCEDURE_NAME

This is an internal function and is not recommended. The name of a stored procedure or function is extracted from the original input of a user.

DBE_DESCRIBE.IS_NUMBER_TYPE

This is an internal function and is not recommended. It is used to determine whether the data type is numeric.

  • DBE_DESCRIBE.GET_PROCEDURE_NAME

    This is an internal function and is not recommended. It is used to extract the name of a stored procedure or function from the original input of a user.

    The prototype of the DBE_DESCRIBE.GET_PROCEDURE_NAME function is as follows:

    1
    2
    3
    DBE_DESCRIBE.GET_PROCEDURE_NAME(
    name IN VARCHAR2)
    RETURNS VARCHAR2;
    
    Table 2 DBE_DESCRIBE.GET_PROCEDURE_NAME interface parameters

    Parameter

    Type

    Input/Output Parameter

    Whether NULL Is Allowed

    Description

    name

    VARCHAR2

    IN

    No

    Entity name.

  • DBE_DESCRIBE.IS_NUMBER_TYPE

    This is an internal function and is not recommended. It is used to check whether the type is numeric.

    The prototype of the DBE_DESCRIBE.IS_NUMBER_TYPE function is as follows:

    1
    2
    3
    DBE_DESCRIBE.IS_NUMBER_TYPE(
    type_oid IN INTEGER)
    RETURNS BOOLEAN;
    
    Table 3 DBE_DESCRIBE.IS_NUMBER_TYPE interface parameters

    Parameter

    Type

    Input/Output Parameter

    Whether NULL Is Allowed

    Description

    type_oid

    INTEGER

    IN

    Yes

    OID of the type.