title: Get stored procedures parameters
body: <p>I try to write code to get the parameters from a stored procedure  </p>
  
  <pre><code>procedure get_proc_parameters(
        in_package_name     in user_arguments.PACKAGE_NAME%type,
        in_procedure_name   in user_arguments.OBJECT_NAME%type,
        io_cursor           in out t_ref_cursor
        )
  is
  
  begin
  
    open io_cursor for
     select ua.ARGUMENT_NAME PARAM_NAME,ua.SEQUENCE PARAM_ORDER
     from user_arguments ua
     where ua.PACKAGE_NAME=in_package_name
       and ua.OBJECT_NAME=in_procedure_name
       and ua.in_out='IN'
  order by ua.SEQUENCE;
  exception
  
  end get_proc_parameters;
  </code></pre>
  
  <p>The code works fine when i have a package name, but no when is null.<br>
  I have some procedures out of packages.<br>
  The code is running if I have:  </p>
  
  <pre><code>  where ua.PACKAGE_NAME is null
  </code></pre>
  
  <p>and not when:</p>
  
  <pre><code>where ua.PACKAGE_NAME = null.
  </code></pre>
  
  <p>How can I make my code work for both situations?</p>