java.sql.SQLException: ORA-01009: missing mandatory parameter

[shashi kumar]

hi i am getting this following error when executing this query
=>

  
( SELECT  rpad('CT',4,' ') || lpad('55',4,0) || lpad('644',3,0) ,1 FROM DUAL UNION   SELECT  rpad('SCT',4,' ') || lpad('5464',4,0) || lpad('456',3,0) ,3 FROM DUAL  )  MINUS  ( SELECT  rpad('CT',4,' ') || lpad('55',4,0) || lpad('644',3,0) ,1 FROM DMS_DOC_ATTACHMENT  where REF_TYPE ='CT' AND REF_NO =( rpad('CT',4,' ') || lpad('55',4,0) || lpad('644',3,0) ) )  MINUS  ( SELECT  rpad('SCT',4,' ') || lpad('5464',4,0) || lpad('456',3,0) ,3 FROM DMS_DOC_ATTACHMENT  where REF_TYPE ='CT' AND REF_NO =( rpad('SCT',4,' ') || lpad('5464',4,0) || lpad('456',3,0) ))