Oracle | ORD_DATASOURCE

Oracle ORD_DATASOURCE_PKG Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

DBMS_LOB

ORDERROR

UTL_FILE

Documented No

First Available 12.1

Security Model Owned by ORDSYS with no privileges granted

Source {ORACLE_HOME}/ord/im/admin/ordcscpk.plb

Subprograms

EXPORT

IMPORTFROM

EXPORT

Copies multimedia data from BLOBs within the database to an external data source ord_datasource_pkg.export( src IN BLOB, dest_type IN VARCHAR2, dest_location IN VARCHAR2, dest_name IN VARCHAR2);

DECLARE

       vBlob BLOB;

      BEGIN

        SELECT iblob

        INTO vBlob

        FROM pdm

        AND fname = 'MyBlob';

      

        ordsys.ord_datasource_pkg.export(bBlob, 'FILE', 'CTEMP', 'myblob.jpg');

      END blob2file;

      /

IMPORTFROM

Import data from the specified external data source to the BLOB specified by the dest parameter

Verified the directory and its permissions as well as the file :the source of the raised exception is not known. ord_datasource_pkg.importfrom( dest IN OUT BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2);

DECLARE

       vBlob BLOB;

      BEGIN

        ordsys.ord_datasource_pkg.importFrom(vBlob, 'FILE', 'CTEMP', 'pdbtest.xml');

      END;

      /

Related Topics

What's New In 20c-21c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx