title: PLS-00428: an INTO clause is expected in this SELECT statement and then ORA-01403: no data found
body: <p>How do I add an INTO statement to this query? I am selecting data from two tables, when the user selects the auction (P62_AUCTION) and bidder (P62_BIDDER), display the auction_no, item_no, item_description, serial_no, and reserve_price from auc_bidding_tb b and auc_auction_list_tb l. Here is my query, I am using the new apex environment</p>
  <pre><code>SELECT distinct
  apex_item.checkbox(1,b.item_no,'UNCHECKED') &quot; &quot;,
  b.auction_no, 
  b.item_no, 
  l.item_description, 
  l.serial_no,
  l.reserve_price
  FROM auc_bidding_tb b, auc_auction_list_tb l 
  where b.auction_no = :P62_AUCTION
  AND b.bidder = :P62_BIDDER
  AND l.auction_no = b.auction_no
  AND l.item_no = b.item_no 
  and l.receipt_number IS NULL;
  </code></pre>
  <p>However I an getting an error:</p>
  <p>ORA-06550: line 1, column 64: PLS-00428: an INTO clause is expected in this SELECT statement</p>
  <p>How do I solve this error?</p>