Oracle: disable a trigger in an stored procedure

execute immediate 'ALTER TRIGGER tr_name DISABLE';

...

execute immediate 'ALTER TRIGGER tr_name ENABLE';

Oracle grant execute

grant execute on aspnetuser.goods_all_get_gtitle_by_gid to pds_sales;

Anonymous PL/SQL block

DECLARE
   gid NUMBER(10):=5850802;
   title varchar2(80);
BEGIN
   IF gid is null THEN
      DBMS_OUTPUT.PUT_LINE('GID is null');
   ELSE
      select t.g_name
      into title
      from typhoon.tbl_goods_all t
      where t.g_id = gid;
      DBMS_OUTPUT.PUT_LINE(title);
   END IF;
END;

Oracle RETURNING Clause - get identity of inserted row

PROCEDURE Ins
(pContactID     OUT Contacts.ContactID%TYPE,
 pFirstname     IN Contacts.Firstname%TYPE,
 pSurname       IN Contacts.Surname%TYPE)
IS
BEGIN
 INSERT INTO Contacts
 (fname, sname)
 VALUES
 (pFirstname, pSurname)
 RETURNING ContactID INTO pContactID;
END;

ORA-01008: not all variables bound

Если код 100 раз проверен, а ошибка есть - лечит ошибку:

command.BindByName = true;

Sql paging in Oracle

select t.*
from (select t.*, row_number() over (order by t.aps_id desc) rn
      from pds_sales.tbl_all_pds_sales t) t
where t.rn > :first and t.rn <= :last