PL/SQL Problem

From: <jweisen_at_my-deja.com>
Date: Wed, 29 Mar 2000 15:36:40 GMT
Message-ID: <8bt7tg$21k$1@nnrp1.deja.com>

I'm trying to write a simple stored procedure that I can pass the acct number too and will delete the associated record, but I'm having some problems (being fairly new to PL/SQL).

CREATE OR REPLACE PROCEDURE PURGE (V_ACCT NUM(9)) AS
BEGIN

        DELETE FROM ADMARC.NAD
        WHERE ADMARC.NAD.ACCT_KEY = V_ACCT

END; I'm also having problems with a triggers on this table which deletes all associated dependancies:

CREATE OR REPLACE TRIGGER Cascade_NAD_Delete

        AFTER DELETE ON ADMARC.NAD
        FOR EACH ROW
DECLARE
        V_ACCT ADMARC.NAD.ACCT_NBR%TYPE;
BEGIN
        DELETE
        FROM ADMARC.INVC
        WHERE ADMARC.INVC.STA_NBR=V_ACCT;

        DELETE
        FROM ADMARC.WO
        WHERE ADMARC.WO.ACCT_KEY=V_ACCT;

        DELETE
        FROM ADMARC.CNR
        WHERE ADMARC.CNR.ACCT_KEY=V_ACCT;

END Cascade_NAD_Delete;

Any help would be appreciated.

Thanks,
John

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 09:36:40 CST