[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

updating error FRM-40401- Oracle Form6i

Posted on 2004-04-13
11
Medium Priority
?
734 Views
Last Modified: 2013-12-12
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....


0
Comment
Question by:GoodHands_Delphi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
11 Comments
 
LVL 3

Expert Comment

by:concon
ID: 10812164
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
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10812183
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
 
LVL 6

Expert Comment

by:musdu
ID: 10812205
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 8

Accepted Solution

by:
annamalai77 earned 80 total points
ID: 10847715
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
 
LVL 6

Expert Comment

by:musdu
ID: 11087940
Hi,

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

regards.
0
 
LVL 8

Expert Comment

by:annamalai77
ID: 11088044
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
 
LVL 3

Expert Comment

by:concon
ID: 11088102
hi,

i am agree with annamalai and musdu.

regards.
0
 
LVL 3

Expert Comment

by:concon
ID: 11088357
ok, i agree.

regards.  
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question