PL/SQL (MOSC)

MOSC Banner

how to handle no data found exception when the function return date ?

edited February 2014 in PL/SQL (MOSC) 8 commentsAnswered

How to handle no data found exception when the function return date and there is no data found

i handled it with sysdate but i want to retrieve nothing when no data found not display the sysdate


here is the code

CREATE OR REPLACE FUNCTION XX_GET_TRX_DATE_RCV_FUNCTION

(P_ORG IN number,P_N_ITEM IN  number,P_PO_NO IN number)

RETURN DATE

IS

vb_trx_date DATE;

     

BEGIN

  

------------------ Description -------------------------

-- This function returns the qty recieved DATE from a specific PO

--------------------------------------------------------     

    

if P_PO_NO is null

then return null;

else

    select TRANSACTION_DATE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center