updating error FRM-40401- Oracle Form6i

hi,

    Block = up_f
    button = btn_update
Oralce form6i

 I have a block named up_f having fields of UPL_STT which has value of 'ERR', i have set my
block to display 10 records..i want to update UPL_STT to value of 'SENT' by clicking btn_update...an error occured " FRM-40414 : No changes to save" here is my script...

Note:
     Disregard the parameters...
***************************
    BEGIN              
       UPDATE UP_F
       SET UPL_STT   = 'SENT'
                WHERE TASK    = 'LDIV' AND
                UPL_STT = 'ERR'  AND
                TRAILER = 'LR88' AND
                SKU     =    'T23133';
               
            IF (v_lst_trl_label = NULL OR v_lst_sku_label = NULL) THEN
                RAISE Bad_Param;
            ELSE
                COMMIT;
           END IF;
     END;

**********************
any idea?

pls help...

regards....


GoodHands_DelphiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

conconCommented:
hi

you could use this proc in order to bypass messages.

PROCEDURE commitwithoutmsg

   vMessageLevel            VARCHAR2(2);

BEGIN

   vMessageLevel := Name_In('SYSTEM.MESSAGE_LEVEL');
   Copy(CONSTANT.DISABLEMESSAGE, 'SYSTEM.MESSAGE_LEVEL');

   COMMIT;

   Copy(vMessageLevel, 'SYSTEM.MESSAGE_LEVEL');

END;

regards.
0
Helena Markováprogrammer-analystCommented:
FRM-40401:  No changes to save - it is not an error, it just indicates that there are no changes in your block.
You can set
 :system.message_level:='10';
and this message will not be displayed.
0
musduCommented:
Hi,

this is not an error message. IT'is an informational message. It says "you did not make any change so you do not need COMMIT". Are you sure about your update statement? It may not update any records? First try your update statement in sql*plus and be sure that it's correct.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

annamalai77Commented:
dear friend

its not error message. as said by musdu.

just set the message level before ur commit statement.

:system.message_level := 5;
commit;
:system.message_level := 0;

include the above line in ur query where u have the commit statement.

regards
annamalai;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
musduCommented:
Hi,

we should accept your comment as correct answer. Because Concon's answer does not have a value for :SYSTEM.MESSAGE_LEVEL.

regards.
0
annamalai77Commented:
hi

i think my response should be included in the assisted answers since it gives solution for the message which our friend is getting.

regards
annamalai
0
conconCommented:
hi,

i am agree with annamalai and musdu.

regards.
0
conconCommented:
ok, i agree.

regards.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.