Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE OR REPLACE PACKAGE Process_Orders AS PROCEDURE Add_Order(p_cno IN orders.cno%TYPE, p_eno IN orders.eno%TYPE, p_received IN DATE); p_creation_date DATE; p_last_update_date DATE; p_created_by VARCHAR2(10); p_last_update_by VARCHAR2(10); p_date DATE; error_message VARCHAR2(100); END Process_Orders; / show errors set echo on CREATE OR REPLACE PACKAGE BODY Process_Orders AS -- Add a new order for the specified class. -- Order_number_seq should be used to populate the order number (ONO) column. PROCEDURE Add_Order(p_cno IN orders.cno%TYPE, p_eno IN orders.eno%TYPE, p_received IN DATE) AS BEGIN INSERT INTO orders (ono,cno,eno,received,creation_date,created_by,last_update_date,last_update_by) SELECT Order_number_seq.NextVal,p_cno,p_eno,NVL(p_received,CURRENT_DATE),CURRENT_DATE, USER,CURRENT_DATE,USER FROM DUAL; COMMIT; EXCEPTION WHEN OTHERS THEN error_message := sqlerrm(sqlcode); DBMS_OUTPUT.PUT_LINE (error_message); INSERT INTO order_errors (ono,transaction_date,message) VALUES (Order_number_seq.NextVal,CURRENT_DATE,error_message); COMMIT; END Add_Order; END Process_Orders; / show errors
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|clob to char in oracle||3||94|
|I tried to perform dml in a table for auditing who perform dml where a after dml trigger also exists in the same table as per rule i tried to handel with autonomous_transaction but still cant perform.||7||39|
|Fill Date time Field||12||31|
|Oracle create type table from existing table%rowtype ?||6||63|