Some of the vital characteristics of SQL

exec InsertOrder;

drop procedure InsertOrder;

CREATE OR REPLACE PACKAGE BODY OrdManagement AS
  FUNCTION MyFunction(Param1 IN NUMBER) RETURN NUMBER IS
  BEGIN
    RETURN Param1;
  END;
  PROCEDURE MyProcedure(Param1 IN NUMBER) IS
    TmpVar NUMBER;
  BEGIN
    TmpVar := Param1;
  END;
  PROCEDURE InsertOrder IS
  BEGIN
  insert into phtOrder(OrderDID,OrderID,ISSACTORDID,OrderCategoryDID)
  values (seq_mLogistics_default.NEXTVAL,'Test127',40883766,217);
  commit;
  END;
END OrdManagement;
-------------------------------------------------------------------------------------------------

exec OrdManagement.InsertOrder;

drop Package OrdManagement;


EXCEPTION
          WHEN OTHERS THEN
              RAISE_APPLICATION_ERROR(-20001,'An error was encountered in addProduct - '||SQLCODE||' -ERROR- '||SQLERRM||'-TRACE-'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

--------------------------------------------------------------------------------------------------


select datediff(TO_DATE('2010/05/04','YYYY/MM/DD'),TO_DATE('2010/05/2','YYYY/MM/DD'))  from dual;

select datediff(TO_DATE('2010/05/04','YYYY/MM/DD'),NULL)  from dual;


CREATE OR REPLACE PROCEDURE InsertOrder IS
BEGIN
   insert into phtOrder(OrderDID,OrderID,ISSACTORDID,OrderCategoryDID)
   values (seq_mLogistics_default.NEXTVAL,'Test126',40883766,217);
 
   commit;
END InsertOrder;