title: ORACLE: NO DATA FOUND -- but data exists
body: <p>Debugging a package procedure and am getting a no data found when there is in fact data.</p>
  
  <p>Testing just the SELECT</p>
  
  <pre><code>SELECT trim(trailing '/' from GL_SECURITY) as DUMMY 
  FROM b2k_user@b2k
  WHERE sms_username = 'FUCHSB';
  </code></pre>
  
  <p>This happily returns my value : '23706*706'</p>
  
  <p>As soon as i try to have this selected INTO i get a NO_DATA _FOUND error 
  (commented out the error handling i put in)</p>
  
  <pre><code>set serveroutput on
  
  DECLARE  
      p_BAS_user_name varchar2(20);  
      v_gl_inclusion varchar2(1000);
      v_gl_exclusions varchar2(1000);
  BEGIN  
      --inputs
      p_BAS_user_name := 'FUCHSB';
      dbms_output.put_line(p_BAS_user_name);    
  ----- GOOD ----- 
  
      --BEGIN
        SELECT trim(trailing '/' from GL_SECURITY) as DUMMY 
        INTO v_gl_inclusion 
        FROM b2k_user@b2k
        WHERE sms_username = p_BAS_user_name;   
      --EXCEPTION
      --  WHEN NO_DATA_FOUND THEN
      --    v_gl_inclusion := 'SUPER EFFING STUPID';
      --END;    
      dbms_output.put_line(v_gl_inclusion);
  
  END;
  
  
  Error report:
  ORA-01403: no data found
  ORA-06512: at line 12
  01403. 00000 -  "no data found"
  *Cause:    
  *Action:
  FUCHSB
  </code></pre>
  
  <p>I can catch the error just fine except for the fact that based on the 1st query i know 100% there is a value for FUCHSB in the database.</p>
  
  <p>Any ideas.. I'm really starting to despise Oracle. Yes this query is being run over a datalink as seen in the 1st query the data is there.</p>
  
  <p>Thanks</p>
  
  <hr>
  
  <p>SOLVED strange behavior in SQL developer caused me to overlook potential whitespace:</p>
  
  <p>It looks as though SQL Developer when running the standalone select applies its own trimming comparator when doing the 'WHERE sms_username = p_BAS_user_name;' portion.. turns out when sitting in the package it does not.. bunch of white space was causing the issue.. still strange that it returns on the normal select. Thanks though!</p>