Creato da pastuweb.com
Share My Page
My Social Accounts
Account FaceBook Account LinkedIn Account Twitter Account Google Plus Account Git Hub

Here there is the procedure:

CREATE OR REPLACE PROCEDURE <user>.LOG(I_TEXT IN VARCHAR2, I_TYPE IN VARCHAR2) IS
  v_id NUMBER;
BEGIN
  select SEQ_WH_SQL_LOG.nextval into v_id from dual;

  insert into WH_SQL_LOG
    (ID_LOG, DATA_LOG, TEXT_LOG, TYPE_LOG)
    values
    (v_id, sysdate, I_TEXT, I_TYPE);

END LOG;

Average (1 Vote)
The average rating is 5.0 stars out of 5.