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
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
Built-in Functions
Built-in Packages
MultiMedia Audio
MultiMedia Image
MultiMedia Video
ORDAUDIOEXCEPTIONS
ORDERROR
ORDERRORCODES
ORDERRORINT
ORDIMAGEEXCEPTIONS
ORDSOURCEEXCEPTIONS
ORDUTIL_PRV
ORDVIDEOEXCEPTIONS
ORD_ADMIN
ORD_AUDIO
ORD_DATASOURCE_PKG
ORD_DICOM
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx