substring in a database trigger

From: Koen Van Vaerenberg <KoenVV73_at_mail.dma.be>
Date: 18 Jan 1999 17:05:34 GMT
Message-ID: <01be4303$f21e7dc0$564290c3@ras-sabena>

hello ,
does anybody knows how to use a substring in a database trigger ?

CURSOR 	C_TRXTYPE IS
SELECT	name    -- you can't use substr here 
FROM	<table_name>
WHERE	cust_trx_type_id = :new.cust_trx_type_id ;


	 OPEN C_TRXTYPE  ;
	 FETCH C_TRXTYPE INTO v_trx_type ;
	 CLOSE C_TRXTYPE ;


         IF  V_TRX_TYPE IS NOT NULL THEN

            v_trx_type_bis := substr(v_trx_type,1,3) ; -- this doesn't work

either

END IF ; This trigger gives a ' value_error' - code...

Thanks in advance

Koen

kds_at_athylon.be Received on Mon Jan 18 1999 - 11:05:34 CST