Lately, I've created a function to get a DESCR field from record EP_TMPL_DEFN of PeopleSoft. Its length is just 30 mixed characters.
I used SQL Developer 3.1, which is default tool of Oracle 12c I'd installed. But when I compile and test a case, it didn't get the result.
At that time, I didn't know why. But I tried to extend my variable length to about 50 and it worked. I asked my dev lead, he used PL/SQL to re-compile my function with only 30 characters in result variable and it worked fine. But if I re-compile again by SQL Developer, it died again. I tried once more with SQL Developer newest version, 4.1.20 but nothing's new.
I have upload a video to describe my problem.
Does anyone have any idea?
https://www.youtube.com/watch?v=AjD4CthCvpY