Solved

FRM-40735 / ORA-01427

Posted on 2004-09-23
1
2,121 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
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

761 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