Oracle | DBMS_TABLE

Oracle DBMS_TABLE_DATA Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose This package provides procedures that can be used to retrieve the byte value of a single column, or a series of columns, in any table. These procedures, along with a publicly documented meta-data structure for columns, can be used to retrieve the row content for row data on which the hash or user signature is computed.

It appears likely that this package is connected to Blockchain tables.

AUTHID CURRENT_USER

Data Types TYPE column_list IS VARRAY(1024) OF VARCHAR2(128);

Dependencies

DBMS_ASSERT	DBMS_TABLE_DATA_LIB	PLITBLM
DBMS_LOB	DBMS_UTILITY

Documented Yes

Exceptions

Error Code	Reason
ORA-05745	no data found from <table_name> column <column_name> at row specified by rowid '<rowid>'

First Available 20c

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmstbdat.sql

Subprograms

GET_BYTES_FOR_COLUMN

GET_BYTES_FOR_COLUMNS

GET_BYTES_FOR_ROW

GET_BYTES_FOR_COLUMN

Undocumented dbms_table_data.get_bytes_for_column( schema_name IN VARCHAR2, table_name IN VARCHAR2, row_id IN ROWID, column_name IN VARCHAR2, column_data IN OUT BLOB);

SELECT rowid, name

      FROM obj$

      WHERE rownum < 6;

      

      ROWID              NAME

      ------------------ ------------------

      AAAAASAABAAAADyAAD ACCESS$

      AAAAASAABAAAA5ZAA3 ACLMV$

      AAAAASAABAAAECBAAZ ACLMV$_BASE_VIEW

      AAAAASAABAAAECBAAY ACLMV$_MVINFO

      AAAAASAABAAAA5ZAA9 ACLMV$_REFLOG

      

      DECLARE

       ridIN   ROWID := 'AAAAASAABAAAADyAAD';

       outVal  BLOB := EMPTY_BLOB();

      BEGIN

        dbms_table_data.get_bytes_for_column(USER, 'TAB$', ridIN, 'SPARE3', outVal);

      

        dbms_output.put_line(TO_CHAR(dbms_lob.getLength(outVal)));

      END;

      /

      1

      

      PL/SQL procedure successfully completed.

GET_BYTES_FOR_COLUMNS

Undocumented dbms_table_data.get_bytes_for_columns( schema_name IN VARCHAR2, table_name IN VARCHAR2, row_id IN ROWID, column_names IN COLUMN_LIST, column_data IN OUT BLOB);

SELECT rowid, name

      FROM obj$

      WHERE rownum < 6;

      

      ROWID              NAME

      ------------------ ------------------

      AAAAASAABAAAADyAAD ACCESS$

      AAAAASAABAAAA5ZAA3 ACLMV$

      AAAAASAABAAAECBAAZ ACLMV$_BASE_VIEW

      AAAAASAABAAAECBAAY ACLMV$_MVINFO

      AAAAASAABAAAA5ZAA9 ACLMV$_REFLOG

      

      DECLARE

       colList dbms_table_data.column_list := dbms_table_data.column_list();

       ridIN   ROWID := 'AAAAASAABAAAADyAAD';

       outVal  BLOB := EMPTY_BLOB();

      BEGIN

        colList.extend(2);

        colList(1) := 'NAME';

        colList(2) := 'SUBNAME';

        dbms_table_data.get_bytes_for_columns(USER, 'OBJ$', ridIN, colList, outVal);

      

        dbms_output.put_line(TO_CHAR(dbms_lob.getLength(outVal)));

      END;

      /

      7

      

      PL/SQL procedure successfully completed.

GET_BYTES_FOR_ROW

Undocumented dbms_table_data.get_bytes_for_row( schema_name IN VARCHAR2, table_name IN VARCHAR2, row_id IN ROWID, column_data IN OUT BLOB);

SELECT rowid, name

      FROM obj$

      WHERE rownum < 6;

      

      ROWID              NAME

      ------------------ ------------------

      AAAAASAABAAAADyAAD ACCESS$

      AAAAASAABAAAA5ZAA3 ACLMV$

      AAAAASAABAAAECBAAZ ACLMV$_BASE_VIEW

      AAAAASAABAAAECBAAY ACLMV$_MVINFO

      AAAAASAABAAAA5ZAA9 ACLMV$_REFLOG

      

      DECLARE

       ridIN  ROWID := 'AAAAASAABAAAADyAAD';

       outVal BLOB := EMPTY_BLOB();

      BEGIN

        dbms_table_data.get_bytes_for_row(USER, 'OBJ$', ridIN, outVal);

      

        dbms_output.put_line(TO_CHAR(dbms_lob.getLength(outVal)));

      END;

      /

      72

      

      PL/SQL procedure successfully completed.