title: in package, how we can create a nested function using PLSQL
body: <p>I tried to create one package . and in the package body  I defined one function.inside that funtion i tried to create another function . I used this logic because i need call that function in my procedure.can you plz help me.</p>
  
  <pre><code>create or replace package L2C_pkg_limit as
  
    function GET_CUST_PROBLEM_DETAILS return number;
  
  end L2C_pkg_limit;
  
  create or replace package body L2C_pkg_limit as
  
  create or replace function nested GET_CUST_PROBLEM_DETAILS return number
  is
     p_cust_diagnostic_cursor_lmt constant number(2)  :=1;
  
       function p_cust_diagnostic_cursor_lmt return number
       is
       begin
         return   p_cust_diagnostic_cursor_lmt;     
       end; 
  
     begin
       return   p_cust_diagnostic_cursor_lmt;    
     end nested  GET_CUST_PROBLEM_DETAILS;  
  end;
  </code></pre>