...
WHEN UTL_FILE.INVALID_OPERATION THEN
UTL_FILE.FCLOSE_ALL(); -- 1. Close all files and 2. RAISE user exception
RAISE_APPLICATION_ERROR(-20102, 'UTL_FILE: INVALID OPERATION.');
-- RETURN; -- Not needed 'cause unhandled user exception will stop program execution.
Check UTL_FILE_DIR...
It 'cause exists MGR IS NULL
SELECT worker.ename
FROM emp worker
WHERE worker.empno not in
(SELECT manager.mgr
FROM emp manager WHERE mgr IS NOT NULL)
^^^^^^^^^^^^^^^^^^^^^
Concatenation operator is '||'. Not '+'.
CREATE TRIGGER ins_uomconv_trig
BEFORE INSERT OR UPDATE ON uom_conversion
FOR EACH ROW
DECLARE
as_xml VARCHAR2(255);
as_from_uom VARCHAR2(20);
as_to_uom VARCHAR2(20);
as_tab_name VARCHAR2(50);
as_oper VARCHAR2(20);
BEGIN
as_from_uom :=...
Yes. Using Oracle Heterogeneous Services
What is Heterogeneous Services?
===============================
Heterogeneous Services (HS) is an integrated component within the Oracle8i database server, and provides the generic technology for accessing non-Oracle systems from the Oracle database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.