Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

query block has incorrect number of result columns

V prasadFeb 13 2011 — edited Feb 13 2011
can anyone edit my query to eliminate below error ??


 SELECT FLROOPENHEAD.RONBR RepairOrder,FLROOPENHEAD.DATEOPENED DateOpened,NULL DateClosed, 
 (SELECT FLREPAIRSTAT.DESCRIPTION  FROM FLREPAIRSTAT 
 WHERE FLREPAIRSTAT.REPAIRSTATID = FLROOPENHEAD.REPAIRSTATID) RepairOrderStatus, 
  (SELECT flrt.DESCRIPTION FROM FLREPAIRTYPE flrt 
  
  WHERE flrt.REPAIRTYPEID = FLROOPENHEAD.REPAIRTYPEID) RepairType,  FLROOPENHEAD.REPAIRCENTER  RepairCenter, 
 FLROOPENHEAD.FLVEHICLEID , FLROOPENHEAD.FLATTACHID,'O'
 FROM FLROOPENHEAD   WHERE FLROOPENHEAD.LDEVNBR =2334 
 AND ((extract(DAY FROM SYSTIMESTAMP - TIMEOPENED)*24)+(extract(HOUR FROM SYSTIMESTAMP - TIMEOPENED)) <= 72)

 UNION 

 SELECT FLROHISTHEAD.RONBR RepairOrder,FLROHISTHEAD.DATEOPENED DateOpened, null, FLROHISTHEAD.DATECLOSED DateClosed, 
 (SELECT FLREPAIRSTAT.DESCRIPTION  FROM FLREPAIRSTAT 
 WHERE FLREPAIRSTAT.REPAIRSTATID =FLROHISTHEAD.REPAIRSTATID) RepairOrderStatus, 
 (SELECT flrt.DESCRIPTION FROM FLREPAIRTYPE flrt
  
 WHERE flrt.REPAIRTYPEID = FLROHISTHEAD.REPAIRTYPEID) RepairType, FLROHISTHEAD.REPAIRCENTER  RepairCenter 
 from FLROHISTHEAD WHERE FLROHISTHEAD.LDEVNBR =2334 
 AND ((extract(DAY FROM SYSTIMESTAMP - FLROHISTHEAD.TIMECLOSED)*24) + (extract(HOUR FROM SYSTIMESTAMP - FLROHISTHEAD.TIMECLOSED)) <= 72)

 ORDER BY DateOpened, RepairOrder



i think error was at second Where condition.
Error at Command Line:1 Column:0
Error report:
SQL Error: ORA-01789: query block has incorrect number of result columns
01789. 00000 -  "query block has incorrect number of result columns"
*Cause:    
*Action:

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 13 2011
Added on Feb 13 2011
4 comments
13,148 views