begin p_my_type.rc_tbl1.co_1 := 1; -- ERRO: "p_my_type.rc_tbl1.co_1" is not variable unknown !!!! p_my_type.rc_tbl1.co_2 := 'Teeeeeeeeeest'; p_my_type.rc_tbl2.co_3 := 'T'; p_my_type.rc_tbl2.co_4 := 10.56; end;
Short answer is that you cannot simply assign components of a composite type one-at-a-time, you have to build up the full final composite result in one expression and assign the result of the expression to the typed variable (p_my_type in this instance).
From:
PG Bug reporting form Date: Subject:
BUG #15246: Does not allow an INOUT parameter to receive values whenits data type is a user-defined data type.