Financials for India - EBS (MOSC)

MOSC Banner

Too_many_rows exception behavior in 12c

Hi All,

We are migrating from oracle 11g to 12c. The table#Prt_PrGrp_Part_Group_Info has 3 records for the below condition. The select statement assigns 'Y' into EXIST_FLAG_TMP in 11g and the same is not getting assigned in 12c(12.2) when it comes through application. The same piece of code is working in 12.1.

DECLARE

EXIST_FLAG_TMP VARCHAR2(1);

BEGIN

EXIST_FLAG_TMP := 'N';

BEGIN

SELECT  'Y' INTO EXIST_FLAG_TMP

        FROM  Prt_PrGrp_Part_Group_Info

        WHERE PrGrp_Crt_OUInstance  = 2

        AND      PrGrp_Status     = 'A';

        EXCEPTION WHEN others THEN NULL;

END;

END;

/

Is there any behavior changes when exact fetch returns more than one row in both versions.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

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