Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: invalid number while trying to Save IG data manually PL/SQL Code

SmithJohn45Jul 18 2024 — edited Jul 18 2024

have a master-detail page, wrote process for line items to save data, when trying to Save it is showing ORA-01722: invalid number
how i can display below values so i can know where is the error? please help.

declare
v_code number;
o_code number := 0;
begin
   case :APEX$ROW_STATUS
        when 'C' then
            Select Nvl(Max(IL_TRANS_LN),0)+1 
              Into v_code 
              from INV_LN 
             WHERE IL_TRANS_CODE = :P182_IH_TRANS_CODE AND IL_FLAG = 'OPEN';
             insert into INV_LN(IL_ORG_ID, IL_TRANS_CODE, IL_TRANS_LN, 
                                IL_ITEM_MODEL, IL_ITEM_LOCATION, ITEM_DESC, 
                                IL_ITEM, IL_UOM, IL_RULE, IL_QTY, IL_UNIT_COST,
                                IL_REMAKRS, IL_CRE_BY, IL_CRE_DATE, IL_AMOUNT, 
                                IL_UNIT_PRICE, IL_OPEN_CODE, IL_FLAG)
             values            (:SESSION_BUS_UNIT, :P182_IH_TRANS_CODE, V_CODE, 
                                :IL_ITEM_MODEL, :IL_ITEM_LOCATION, :ITEM_DESC,
                                :IL_ITEM,:IL_UOM, :IL_RULE, :IL_QTY, :IL_UNIT_COST,
                                :IL_REMAKRS, :APP_USER, SYSDATE, :IL_AMOUNT, 
                                :IL_UNIT_PRICE, :P182_IH_TRANS_CODE, 'OPEN')
             returning v_code into :IL_TRANS_LN;
        end;
    end case;
end;

regards

This post has been answered by jariola on Jul 18 2024
Jump to Answer
Comments
Post Details
Added on Jul 18 2024
2 comments
142 views