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