title: how to printf in oracle stored procedure (for debugging purposes)?
body: <p>I'm trying to debug a stored procedure (Oracle). I want to print some variables. </p>
  
  <p>I don't know what the command to print is (or where to find it). Can anyone tell me what it is?</p>
  
  <p>Thanks</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>This is my trigger:</p>
  
  <pre><code>create or replace
  procedure bns_saa_confs_update_state (
    theID in varchar2
  )
  AS
  begin
    UPDATE BNS_SAA_CONFIRMATIONS SET SentToWssStatus='T' WHERE ID=theID;
    commit;
  end;
  </code></pre>
  
  <p>I want to print theID</p>