Quellcode Prozedur q_01hier_ktr

[ Überblick   Tabellen  Views  Prozeduren  Trigger  q_01hier_ktr ]

Das DB-Objekt selbst

CREATE PROCEDURE "demoadm".q_01hier_ktr(
  a_hier        char(5)   -- hierarchy name (short)
)
  DELETE FROM hier_ktr_hn WHERE (hier_nr = a_hier) AND (mandant = '01');
  DELETE FROM hier_ktr_10 WHERE (hier_nr = a_hier) AND (mandant = '01');
END PROCEDURE

Abhängige Objekte, Rechte

grant  execute on "demoadm".q_01hier_ktr to "public" as "demoadm";

HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07