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!

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:

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2011

Added on Feb 13 2011

4 comments

13,173 views