Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Display Stored Procs Local Variable Value

    In the Stored Procs, I has few variables assgined with value. On the debug mode, if I want to display the variable value. How can I do it?

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    PHP Code:
    sql > declare
      
    2  begin
      3    
      4    
    for i in 1..10 loop
      5  
      6       Dbms_Output
    .Put_LineTo_Char()|| '  <-- is my loop number ');
      
    7  
      8    end loop
    ;
      
    9  end;
     
    10  /
    1  <-- is my loop number
    2  
    <-- is my loop number
    3  
    <-- is my loop number
    4  
    <-- is my loop number
    5  
    <-- is my loop number
    6  
    <-- is my loop number
    7  
    <-- is my loop number
    8  
    <-- is my loop number
    9  
    <-- is my loop number
    10  
    <-- is my loop number

    PL
    /SQL procedure successfully completed
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •