Questions tagged [ora-01422]
19 questions
2
votes
1 answer
Too Many Rows throwing but only one is selected
I have this procedure which just deletes a row based on a column field called AppID. This procedure get's a value from another column called AppNbr based on that rows AppID column. The procedure is failing with a TOO_MANY_ROWS exception when it…
Jimenemex
- 3,104
- 3
- 24
- 56
2
votes
2 answers
Why is Oracle SELECT INTO statement throwing error?
I write a code to create procedure in oracle, It's successful created but when RUN from sql developer to view output it's show error.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "TESTUSER.USER_FEEDBACK", line…
Rajiv Choudhary
- 141
- 2
- 14
2
votes
0 answers
Ref to FSP_AFTER_LOGIN_URL causes ora-01422
Oracle Apex 4.2.5, Oracle 12c database issue. The Oracle Apex application I'm working on is a single workspace with two parsing schemas. The main back office application is made up of a number of workspaces parsed by one schema.
The application…
Mark Killick
- 21
- 3
2
votes
2 answers
Using bind variables in SQL Plus with more than one row returned?
This is a stupid problem, but I can't seem to get around it. I have a query that's causing trouble in an OCI program, so I want to run it manually in SQL*Plus to check if there is any difference there. This is the query:
select e.label as doc_name,
…
TrojanName
- 4,853
- 5
- 29
- 41
1
vote
3 answers
Reason for geting ORA-01422: exact fetch returns more than requested number of rows
So i am working on an installer where the installer connects to a database and creates tables and populates them.
Every aspect of this works correctly except when i attempt to add rows to a certian table.
declare
retVal INTEGER;
rptID INTEGER;
…
James213
- 957
- 5
- 31
- 57
1
vote
2 answers
ORA-01422: exact fetch returns more than requested number of rows for trigger
I tried to insert new rows to check if my trigger works. But it returns the error in the title
Yilin
- 41
- 3
1
vote
1 answer
ORA-01422: exact fetch returns more than requested number of rows )shows for a trigger
I have tired to create a trigger like this,
but it shows this error
Yilin
- 41
- 3
1
vote
3 answers
ORA-06512:exact fetch returns more than requested number of rows
While running the below procedure I am getting the below error
Error report:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "my_db.CREATE_CTAB_FILE", line 51
ORA-06512: at line 2
01422. 00000 - "exact fetch returns…
bharat005
- 57
- 2
- 7
1
vote
1 answer
ORA-01422 - exact fetch returns more than requested number of rows error
I am a newbie in writing PL/SQL. I have this small code, but unable to print out the output due to the subject error.
declare
output_tour_id varchar(4000);
begin
dbms_output.enable;
for r in
(
SELECT TOUR_ID FROM "/DSD/HH_RADELHD"
VERSIONS…
4dirk1
- 29
- 3
1
vote
1 answer
ORA-01422: exact fetch returns more than requested number of rows in RETURNING INTO
I have the following sql (oracle) that removes all rows from a table except the 100 newest.
DELETE FROM my_table tab_outer
WHERE tab_outer.rowid IN (
-- Fetch rowids of rows to delete
SELECT rid FROM (
SELECT rownum r, rid FROM (
…
Joel Palmert
- 173
- 1
- 3
- 9
0
votes
1 answer
Date comparison error when storing with into
Im almost done with a procedure i started yesterday, but on the last step i have found a problem that happens only if a comparison is done with an if clause. The procedure shows all the information of a match if you introduce a football league round…
Wazabi
- 83
- 5
0
votes
1 answer
Oracle Forms Post-Query FRM-40735 and ORA-01422
I want to display the item from different table, I am using POST-QUERY trigger
:
SELECT Stock_code
INTO :exchange.stockcode
FROM Exchange_Stock
WHERE Exchange_code = :exchange.Exchange_code;
it come up with FRM-40735 and ORA-01422
but it…
Parco Guan
- 33
- 1
- 7
0
votes
1 answer
PL/SQL ORA-01422 Error for SELECT INTO, Oracle Anonymous Block (NOVA Environment)
Getting the following Error: ORA-01422: exact fetch returns more than requested number of rows ORA-6512
New to PL/SQL and although I KNOW this query should be conducted via standard SQL, I am trying to figure out how to accomplish this using…
StevenC
- 109
- 1
- 20
0
votes
5 answers
Oracle scheduled job fails
I am using Oracle 10g and using following script to create the job
CREATE OR REPLACE PROCEDURE archtemp AS
BEGIN
UPDATE ARCH_TEMP SET ARCH_DATE = SYSDATE;
COMMIT;
END archtemp;
VAR jobno NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:jobno,…
Atti
- 3
- 1
- 3
0
votes
1 answer
ORA-01422, but Query works fine
I'm getting absolutely crazy over this.
I'm currently writing a trigger to change some dates around. For that I want to get a max value into a variable like so:
SELECT date INTO datevar
FROM table
WHERE date = (SELECT…
Torsten N.
- 2,051
- 1
- 12
- 17