Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12c Inline function not working in SQL Developer

Shamed HSep 1 2017 — edited Sep 11 2017

Hi,

I tried running the below inline function in SQL Developer

with function calculator (m number, r number) return number

is begin

return m * r;

end calculator;

select calculator(3, 2) as calc from dual;

But throws below error

pastedImage_2.png

SQL Developer version : Version 3.2.20.09

Oracle Data base : 12c

Please note , when I run from SQLPlus I am getting the intended output

Regards,

Shamed H
This post has been answered by BluShadow on Sep 1 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2017
Added on Sep 1 2017
#sql-pl-sql
8 comments
1,282 views