Home » SQL & PL/SQL » SQL & PL/SQL » Multiple Out Parameters Function in Select Statement - Oracle (Oracle 11.2.0.3.0)
Multiple Out Parameters Function in Select Statement - Oracle [message #677939] Thu, 24 October 2019 23:35 Go to previous message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
create or replace function myFunc(a in number, b in number, c out number) return varchar2 is
  Result varchar2(100);
begin
  c:= a+b;
  result := 'Success';
    return(Result);
  exception when others then
    result := 'Failure';
  return(Result);
end myFunc;

I want to use this function in Select statement.
any help please.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Cursor throwing error while passing to dbms_stats.gather_schema_stats
Next Topic: ANALYZE TABLE STATEMENT
Goto Forum:
  


Current Time: Fri Apr 19 12:32:27 CDT 2024