In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display a record as Non-Updateable. It need to show a message to the user. How it is possible. Thanks in Advance.
Madhuri This is not possible where the message will be printed if you execute Table from another environment like Java Net. In SQL I think it is not possible.
RE: In pl/sql I need to get like this scenario. if i a...
Madhuri Its Correct but Its always recomand that you use BEFORE INSERT rather than AFTER INSERT for this situation. This Triggering Environment is applicable to any third-party application also Like JAVA..NET etc
Regds Ramki YERRA IBM India Pvt LTD Bangalore-71 ramakrishna . yerra @ in . ibm . com
RE: In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display a record as Non-Updateable. It need to show a message to the user. How it is possible.Thanks in Advance.
You can user sql rowcount to check whether the dml does something or not eg
begin delete from tbl_xxx where col_yyy 'ASDF'; dbms_output.put_line (sql rowcount); end;
RE: In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display a record as Non-Updateable. It need to show a message to the user. How it is possible.Thanks in Advance.
CREATE OR REPLACE TRIGGER SHOW_BEFORE_DML BEFORE INSERT OR DELETE OR UPDATE ON SERVICE_ORDER_STATUS --(TABLE NAME)
FOR EACH ROW BEGIN DBMS_OUTPUT.PUT_LINE('NON-UPDATABLE TABLE'); ROLLBACK; END;
