Oracle | OJDS_NAMESPACE

Oracle OJDS_NAMESPACE Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Database support for Oracle Java Directory Service

AUTHID CURRENT_USER

Dependencies

STANDARD (only)

Documented No

Exceptions

Error Code	Reason
ORA-29532	Java call terminated by uncaught Java exception

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/javavm/install/ojds_namespace.sql

Subprograms

Executes the command ojds_namespace.execute RETURN NUMBER; PRAGMA SUPPLEMENTAL_LOG_DATA(execute, NONE);

SELECT ojds_namespace.execute

      FROM dual;

      *

      ERROR at line 2:

      ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalStateException

      
      -- to be successful you must previously have used 
      WRITE to provide a command to execute

READ

Reads the serialized result following command execution ojds_namespace.read RETURN LONG RAW; PRAGMA SUPPLEMENTAL_LOG_DATA(read, READ_ONLY);

CREATE TABLE t(

      col CLOB);

      

      DECLARE

       retVal BLOB;

      BEGIN

        retVal := ojds_namespace.read;

        INSERT INTO t

        (col)

        VALUES

        (TO_CLOB(retVal));

      END;

      /

      -- will return a result only if a command has been executed

WRITE

Writes the serialized command to be executed ojds_namespace.write(bytes IN LONG RAW); PRAGMA SUPPLEMENTAL_LOG_DATA(write, READ_ONLY);

TBD