Please check this syntax

From: Josh White <whitegoose_at_inorbit.com>
Date: 30 Mar 2005 19:42:43 -0800
Message-ID: <aafea0a8.0503301942.5ac37083@posting.google.com>

Hi,

I'm new to PL/SQL and am currently writing some triggers for work - even though I won't actually have anything on my machine that can check the syntax until late next week - it's a long story.

So someone please check the syntax of this simple trigger for me?

---

CREATE OR REPLACE TRIGGER hia_iu_Comp
AFTER INSERT OR UPDATE
ON COMP
REFERENCING NEW AS new_Row OLD AS oldRow FOR EACH ROW DECLARE

v_compType VARCHAR2(4);
v_sql VARCHAR2(500);
v_bgtNo VARCHAR2(24);

BEGIN


	-- Get the type of asset

	SELECT v_compType = CT.COMPCODE
	FROM COMP C, COMPTYPE CT
	WHERE C.COMPTYPE = CT.COMPTYPE
	AND C.COMPKEY = :newRow.COMPKEY
	


	-- Build SQL to get budget number

	v_sql := 'SELECT C.BGTNO FROM COMP' || v_compType || ' C WHERE

C.COMPKEY = :newRowCompKey'         

        EXECUTE IMMEDIATE v_sql INTO v_bgtNo USING :newRow.COMPKEY; END

---

Thanks,
Josh. Received on Wed Mar 30 2005 - 21:42:43 CST