Oracle | ORD_DATASOURCE

Oracle ORD_DATASOURCE_PKG Version 21c

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 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;

      /