Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: substring in a database trigger

Re: substring in a database trigger

From: Hyungki Kim <gamjada_at_yahoo.com>
Date: Mon, 18 Jan 1999 22:02:59 -0800
Message-ID: <xAVo2.2217$IJ3.19812327@WReNphoon2>


Hello.

In your code, 'value_error' means the variable 'v_trx_type_bis' is smaller in size than
'substr(v_trx_type,1,3)' or has different data type.
So, you can bypass the 'value_error' by increasing the size of
'v_trx_type_bis' or changing that

data type.
But, I think, using alias in SELECT-list is better.

Thank you.

Received on Tue Jan 19 1999 - 00:02:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US