Solved

FRM-40106: No navigable items in block

Posted on 2004-03-26
2
5,551 Views
Last Modified: 2012-10-31
I receive the following error FRM-40106: No navigable items in block when I try to enter a block on an existing record. WHat does this mean.
0
Comment
Question by:uTab
[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
2 Comments
 
LVL 8

Accepted Solution

by:
baonguyen1 earned 50 total points
ID: 10693413
Hope this helps you:

Input: FRM-40106

Error Summary
FRM 40106 No enterable items in destination block. (Oerr:FRM.40106)
-------------------------------------------------------------------------------
Error Details
-------------------------------------------------------------------------------
Error: FRM 40106
Text: No enterable items in destination block.
-------------------------------------------------------------------------------
Cause: Runtime error. A GO_BLOCK statement references a block with no enterable items.
Action: Remove the statement or make at least one item in the block enterable.

Additional: Relating to Query only Items
----------------------------------------

If the only Item in the block is defined as the following:
Enabled = FALSE
Navigable = TRUE
Insert Allowed = FALSE
Query Allowed = TRUE
Update Allowed = FALSE

Then GO_BLOCK will generate this error, but GO_ITEM direct to the item will work.

0
 

Expert Comment

by:327590263
ID: 38551823
thanks for your comments.

I have same issue but I have several items with below attributes, why do I still have same error
Enabled = TRUE  
Navigable = TRUE
Insert Allowed = TRUE
Query Allowed = TRUE
Update Allowed = TRUE
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup
Suggested Courses

623 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