Kamal

• May 23rd, 2015

 

Yes, you can return from exception block.
example: create or replace function TestReturn return varchar2 is
Result varchar2(1);--size 1
begin
Result := 123;--size 3
return Test;

exception when others then
return sqlerrm;
end TestReturn;
---------------------------
declare
test_ varchar2(100);
BEgin
test_ := TestReturn();
dbms_output.put_line(test_);
end;
.above code returns the exception
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Aryan

• May 26th, 2015

 

Yes it is possible to use Return in exception block of pl/sql.
Example:

Code
CREATE OR REPLACE FUNCTION <function_name> [(input/output variable declarations)] RETURN return_type


[AUTHID <CURRENT_USER | DEFINER>] <IS|AS>   -- heading part


amount NUMBER;   -- declaration block


BEGIN   -- executable part


        <PL/SQL block WITH RETURN statement>


        RETURN <return_value>;


[EXCEPTION


        none]


        RETURN <return_value>;


END;