sql function [message #394903] |
Mon, 30 March 2009 14:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dvbaskar
Messages: 5 Registered: March 2009 Location: UAE
|
Junior Member |
|
|
i call the function in sql command prompt :
er_msg : OUT parameter
select get_master('bbb','kgs','lbs',122,:er_msg) from tablename;
i got the error 'function has out arguments'
how to get the values in sql?
how to define the variable in sql prompt and return the value
same function i want to call to in the report also
reply me
|
|
|
Re: sql function [message #394908 is a reply to message #394903] |
Mon, 30 March 2009 16:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You can't call a function with out parameters in SQL. It only works in PL/SQL.
In sqlplus you'd need to call it from a begin/end block.
In reports you'd need to use a program unit.
It's generally advisable to avoid functions with out parameters for this reason.
|
|
|
Re: sql function [message #395514 is a reply to message #394903] |
Wed, 01 April 2009 12:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
If function returns a single value, why would you use OUT parameter anyway? If possible, get rid of it.
|
|
|