The code is inserting based on select from a view created using with keyword.
insert into temp
(
fill,
col4,
col5
)
with v_sel as
(
select col1,col2,col3,col4,col5 from weight
)
select
col1||col2||col3 as fill,
col4,
col5
from v_sel;
Here when concatenation it throws exception that the string is too long.
ORA-01489: result of string concatenation is too long
With this kind of structure how can I print the values col1,col2,col3 / fill column in an exception block.
I have used exceptions in cursor programming. But with “With Clause Query” I'm not able to add exception and print the values.
Please help.