Hello ,
If you want to call a plsql function in select clause inside plsql pkg !! the plsql function has to be a public declaration not private.
you may find error :
PLS-00231: function may not be used in SQL.
Solution
Declare the function in plsql spec or create that function as stanalone.
True or declare it as an inline function.
ReplyDelete