Solved

FRM-40735 / ORA-01427

Posted on 2004-09-23
1
2,135 Views
Last Modified: 2008-03-17
Hello,

Running my WebForms at Runtime when trying to execute a query, I get the following error:

FRM-40735: KEY-NEXT-ITEM trigger raised unhandled exception ORA-01427.

1) Your toughts ?

PT
0
Comment
Question by:ptreves
[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
1 Comment
 
LVL 3

Accepted Solution

by:
dnarramore earned 500 total points
ID: 12135508
It sounds like you have a query in your KEY-NEXT-ITEM trigger where there is a subquery that returns more than one row.

You probably need to modify that query.  Maybe use DISTINCT, or IN instead of = or change the WHERE clause in the subquery so it just returns one value.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

690 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