Hello experts,
I don't understand this problem on livesql. The following code is not running. What am I missing ?
with function f_val(i_p in number)
return varchar2
is
begin
return to\_char(to\_date(i\_p,'J'),'Jsp');
end;
select f_val(level) as val from dual connect by level <= 10;
The above is perfectly fine and runs without any error on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.
But the same is erroring out like below on livesql (which is Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production). Any idea why ?
Regards,
Ranagal