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