I have problem with c# code using sql in Toad for oracle

[nisarg25]

I have problem with c# code using sql in Toad for oracle I am using Active reports.

The error is:

No data exists for the row or column

When I write the same query in Active reports.

Query in Toad

SELECT PI.proposalitem_linenum AS prop_linenum, 
        RI.Refitem_NM AS refitem_nm,  
        PI.QTY AS qty,
        PI.UNITPRICE AS Unit_price,
        PI.EXTENDEDAMOUNT AS Ext_amt,
        B.BIDPRICE AS Bid_price,
        B.EXTENDEDAMOUNT AS Ext_bid_amt
from  proposal p, proposalitem pi, bid b, proposalvendor pv, refvendor rv, refitem ri 
where P.PROPOSAL_ID =  2261 
and B.EXTENDEDAMOUNT > (PI.EXTENDEDAMOUNT * 1.15)
and pi.proposal_id = p.proposal_id 
and b.proposalitem_id = pi.proposalitem_id 
and pv.proposalvendor_id = b.proposalvendor_id 
and rv.refvendor_id = pv.refvendor_id 
and ri.refitem_id = pi.refitem_id 
ORDER by p.callorder, P.PROPOSAL_ID, p.contract_nm, pi.proposalitem_linenum, ri.refitem_nm, ri.descr, B.EXTENDEDAMOUNT, PI.EXTENDEDAMOUNT

Query in Active reports

string sql = "SELECT PI.proposalitem_linenum AS prop_linenum, " +
                         "RI.Refitem_NM AS refitem_nm,   " +
                                     "PI.QTY AS qty, " +
                                     "PI.UNITPRICE AS Unit_price, " +
                                     "PI.EXTENDEDAMOUNT AS Ext_amt, " +
                                     "B.BIDPRICE AS Bid_price, " +
                                     "B.EXTENDEDAMOUNT AS Ext_bid_amt " +
"FROM  DBA_WEBTRNSPORT.proposal p, DBA_WEBTRNSPORT.proposalitem pi, DBA_WEBTRNSPORT.bid b, DBA_WEBTRNSPORT.proposalvendor pv, DBA_WEBTRNSPORT.refvendor rv,DBA_WEBTRNSPORT.refitem ri  " +
                                "where P.PROPOSAL_ID = '" + proposalID + "'     " +
                                "and B.EXTENDEDAMOUNT > (PI.EXTENDEDAMOUNT * 1.02) " +
                                "and pi.proposal_id = p.proposal_id  " +
                                "and b.proposalitem_id = pi.proposalitem_id  " +
                                "and pv.proposalvendor_id = b.proposalvendor_id  " +
                                "and rv.refvendor_id = pv.refvendor_id  " +
                                "and ri.refitem_id = pi.refitem_id  " +
                                "ORDER by p.callorder, P.PROPOSAL_ID, p.contract_nm, pi.proposalitem_linenum, ri.refitem_nm, ri.descr, B.EXTENDEDAMOUNT, PI.EXTENDEDAMOUNT ";