'why oracle user defined function shows error in Oracle Sql Developer 4.0.3.16
In Oracle SQL Developer Version 1.5.4, same code doesn't give any error. I am currently connected to oracle 11g database server.
create or replace function getdate
RETURN VARCHAR2 IS
v_datevalue date;
begin
v_datevalue := '01-APR-2015';
return (cast(v_datevalue as varchar2));
end;
/
Solution 1:[1]
error has occurred ORA-01858: a non-numeric character was found where a numeric was expected enter image description here
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | user19129252 |