PL/SQL (MOSC)

MOSC Banner

ORA-01427: single-row subquery returns more than one row

edited Jan 28, 2016 10:01AM in PL/SQL (MOSC) 3 commentsAnswered

how to resolve this error?

UPDATE test_instance a
SET TEST_FLOW_SEQUENCE_VERSION =
  (SELECT version
  FROM testflow_report_versions tfrv
  WHERE a.TEST_FLOW_REPORT_ID = tfrv.report_id 
  )
WHERE a.TEST_FLOW_REPORT_ID IN
  (SELECT TEST_FLOW_REPORT_ID
  FROM test_instance
  WHERE TEST_FLOW_REPORT_ID IS NOT NULL
  );

Giving error:
Error report -
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 -  "single-row subquery returns more than one row"
*Cause:   
*Action:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center