Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

Oracle Error 54013 (ORA-54013)
-- When data is inserted into Oracle tables with virtual columns, the 
-- virtual columns have to be skipped in the insert statement.  Using 
-- syntax as shown below will result in error (ORA-54013)

INSERT INTO edw_sales_detail
SELECT * FROM  edw_sales_detail
WHERE sales_tran_id = 4;

Oracle Error 54013 (ORA-54013)

-- The error can be avoided by just excluding the virtual columns in 
-- the insert statement.

INSERT INTO edw_sales_detail(
   --sales_tran_id,            -- before insert trigger
   loc_id, cust_id,
   invoice_num, invoice_date,
   sales_amt, tax_amt, freight_amt) 
  SELECT
    1, 10,
    '1003', TO_DATE(20141211,'yyyymmdd'),
    2000.00, 100.00, 25.00
  FROM  DUAL;

COMMIT;

Oracle Error 54013 (ORA-54013) Resolved

Table creation details => Multi Row Load


Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: December 24, 2014

  39897