Build dynamic table
Terry Kelly, July 15, 2016 - 12:58 pm UTC
Worked like a champ,,, thank you so much!!
July 16, 2016 - 4:39 am UTC
glad we could help.
(Just tread carefully when dynamically building *anything*... you can get into sql injection territory)
compilation error
Dash, June 19, 2019 - 8:29 pm UTC
CREATE OR REPLACE TRIGGER orders_bffr_before_delete
BEFORE DELETE ON nufast.eai_orders_bffr
FOR EACH ROW
BEGIN
-- Insert record into audit table
INSERT INTO nufast.eai_orders_bffr_audit
(order_key,
order_type,
premise_key,
cis_account,
compl_date,
order_status,
delete_date)
VALUES
(:old.order_key,
:old.order_type,
:old.premise_key,
:old.cis_account,
:old.compl_date,
:old.order_status,
SYSDATE);
END orders_bffr_before_delete;
/
getting the error :Error during Execute
S1000(6550)[Oracle][ODBC][Ora]ORA-06550: line 5, column 10:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
;
June 23, 2019 - 6:45 pm UTC
Running it in SQL Developer? If so, remove the whitespace lines.