title: Calling package's procedure from another procedure
body: <p>Trying to search but i couldn't find it. </p>
  
  <p>I have a package name <code>package_1</code> and in that I have multiple procedures/functions. Now I want to call one of these functions from another procedure, which is not part of this package. I can't put this code in that package (both are on same schema). </p>
  
  <p>I am trying this</p>
  
  <p><code>package_1.function_1(varchar_var_1, varchar_var_2, varchar_var_3);</code></p>
  
  <p>But it is giving me error. </p>
  
  <p><strong>QUESTION2</strong>
  The above functions return an object which is a record type defined in package. How can I declare an object of that type in my procedure so that I can assign response in my procedure ? </p>