Quellcode Prozedur q_02hier_kst

[ Überblick   Tabellen  Views  Prozeduren  Trigger  q_02hier_kst ]

Das DB-Objekt selbst

CREATE PROCEDURE "demoadm".q_02hier_kst(
  a_hier        char(5)   -- hierarchy name (short)
)
  DELETE FROM hier_kst_hn WHERE (hier_nr = a_hier) AND (mandant = '02');
  DELETE FROM hier_kst_10 WHERE (hier_nr = a_hier) AND (mandant = '02');
END PROCEDURE

Abhängige Objekte, Rechte

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

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