Re: webdb problems

From: <stoffip_at_my-deja.com>
Date: 2000/07/26
Message-ID: <8lm4ti$3kq$1_at_nnrp1.deja.com>#1/1

In article <8lklib$8po$18$1_at_news.t-online.com>,   "Klaus Zeuch" <KZeuch_at_nospamhotmail.com> wrote:
> Searched webdb forum in metalink for that error - no posting. Can you
 post
> the ddl-statements for your tables and your view? Which kind of webdb-
 form
> are you using?
>
> Klaus

i am using the form on tables on webdb
and that are the scirpt of the view and the trigger, the tables are to big to post there here :-)
View:

CREATE OR REPLACE VIEW WWW_ANMELDUNG_VIEW ( KURS_ID,

TNM_VORNAME, TNM_NACHNAME, TNM_GEM_ID_WOHNT_IN, TNM_PLZ,
TNM_STRASSE, TNM_GEBURTSDATUM, TNM_GEM_ID, TNM_VORWAHL1,
TNM_TELEFON1, TNM_VORWAHLFAX, TNM_FAX, TNM_EMAIL,
TNM_ID, TNM_ERSTELLUNGSDATUM, TNM_AENDERUNGSDATUM, KURS_KURSTITEL,
KURS_DATUMVON, KURS_DATUMBIS, KURS_UHRZEITVON, KURS_UHRZEITBIS,
KURS_NUM, KURS_BESCHREIBUNG, KURS_ANMERKUNGEN, KURS_DAUER_IN_EIGEN_UE,

KURS_KURSTAGE, KURS_ZIELGRUPPE, KURS_GEBUEHR, KURS_SPR_ID, KURS_GEM_ID, KURS_KKD_ID, KURS_ORG_ID, TNA_TNM_ID, TNA_KURS_ID, TNA_ANGEMELDETAM, TNA_ISTANGEMELDET ) AS SELECT KURS_ID,TNM_VORNAME,

TNM_NACHNAME,TNM_GEM_ID_WOHNT_IN,TNM_PLZ,TNM_STRASSE ,TNM_GEBURTSDATUM ,
TNM_GEM_ID,
TNM_VORWAHL1, TNM_TELEFON1, TNM_VORWAHLFAX, TNM_FAX,
TNM_EMAIL,TNM_ID , TNM_ERSTELLUNGSDATUM, TNM_AENDERUNGSDATUM,
KURS_KURSTITEL, KURS_DATUMVON, KURS_DATUMBIS, KURS_UHRZEITVON,
KURS_UHRZEITBIS,
KURS_NUM, KURS_BESCHREIBUNG, KURS_ANMERKUNGEN,
KURS_DAUER_IN_EIGEN_UE,

KURS_KURSTAGE, KURS_ZIELGRUPPE, KURS_GEBUEHR, KURS_SPR_ID, KURS_GEM_ID, KURS_KKD_ID, KURS_ORG_ID, TNA_TNM_ID, TNA_KURS_ID, tna_angemeldetam, tna_istangemeldet FROM KURSE, TEILNEHMER, TEILNAHMEN
WHERE TEILNAHMEN.tna_kurs_id = KURSE.kurs_id AND TEILNAHMEN.tna_tnm_id = TEILNEHMER.tnm_id

Trigger:

TRIGGER TRG_II_WWW_ANMELDUNG_VW
INSTEAD OF INSERT ON WWW_ANMELDUNG_VIEW REFERENCING
 NEW AS NEW
 OLD AS OLD
FOR EACH ROW
DECLARE
   v_nextid NUMBER;

 BEGIN
 SELECT pers_id_seq.NEXTVAL INTO v_nextid FROM dual;

 INSERT INTO TEILNEHMER
        (TNM_ID, TNM_VORNAME, TNM_NACHNAME, TNM_GEM_ID_WOHNT_IN, TNM_PLZ,

         TNM_STRASSE, TNM_GEBURTSDATUM, TNM_GEM_ID, TNM_VORWAHL1,
         TNM_TELEFON1, TNM_VORWAHLFAX, TNM_FAX, TNM_EMAIL,
         TNM_ERSTELLUNGSDATUM, TNM_AENDERUNGSDATUM )
 VALUES
        ( v_nextid,:NEW.TNM_VORNAME, :NEW.TNM_NACHNAME,
          :NEW.TNM_GEM_ID_WOHNT_IN, :NEW.TNM_PLZ,
          :NEW.TNM_STRASSE, :NEW.TNM_GEBURTSDATUM, :NEW.TNM_GEM_ID,
          :NEW.TNM_VORWAHL1,
          :NEW.TNM_TELEFON1, :NEW.TNM_VORWAHLFAX, :NEW.TNM_FAX, :NEW.TNM
_EMAIL,
           SYSDATE, SYSDATE);

 INSERT INTO  TEILNAHMEN
        (TNA_TNM_ID, TNA_KURS_ID, tna_angemeldetam, tna_istangemeldet )
 VALUES
        (v_nextid,:NEW.KURS_ID, SYSDATE, 1);

  EXCEPTION
    WHEN OTHERS THEN
      RAISE;
  END; thanx chris

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 26 2000 - 00:00:00 CEST