substring in database trigger

From: Koen Van Vaerenberg <KoenVV73_at_mail.dma.be>
Date: 18 Jan 1999 16:59:26 GMT
Message-ID: <01be4303$16e7b780$564290c3_at_ras-sabena>

hello ,
[Quoted] [Quoted] 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 ; [Quoted] This trigger gives a ' value_error' - code...

Thanks in advance

Koen

kds_at_athylon.be Received on Mon Jan 18 1999 - 17:59:26 CET