Database Administration (MOSC)

MOSC Banner

inconsistent result after upgrade to 11g

edited Jan 22, 2015 10:05AM in Database Administration (MOSC) 9 commentsAnswered

Database was upgraded from 10.2.0.4 t0 11.2.0.4

The below function returns opposite results in 10g (N - No currency indicator) and 11g (Y = no currency indicator).

DECLARE


L_brand division.division%TYPE;
L_po_type_string             csi_uda_ff.uda_txt_des%TYPE;
L_ord_type_des               ord_ext.ord_type_des%TYPE;
L_no_currency_ind            csi_uda_val.uda_val_des%TYPE;

CURSOR c_get_no_currency_ind(P_brand        division.division%TYPE,
  P_po_type csi_uda_ff.uda_txt_des%TYPE,
  P_ord_type_des ord_ext.ord_type_des%TYPE --<ANF 4.04>
  )
IS
select distinct csi_uda_val

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