Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: substring in a database trigger
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.