need output without using dbms_output package

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kalpanareddy16
    New Member
    • Sep 2008
    • 1

    need output without using dbms_output package

    1 declare 2x1 number;
    3 begin 4x1 :=5;
    5 declare 6x2 number ;
    7 begin 8x2 :=6;
    9 x1:=x2 ;
    10 end;
    11 x2 := X1 ;
    12 * end;
    13 / x2 :=X1;
    *error at line 11:ORA-06550 :line 11,column 1:PLS-00201: identifier 'X2' must be declared ORA-06550:line 11,column1: PL/SQL:statement ignored while executing the above nested block, getting the error as"identifier 'X2' must be declared".witho ut declaring the variables inside the block how can u use the variable.Also i want to view the output of that variable without using DBMS_OUTPUT package.
  • Dave44
    New Member
    • Feb 2007
    • 153

    #2
    this is hard to reply to. You need to grab a book and get some of the fundamental PL/SQL syntax learned. variables need to be declared and if the scope of a variable is beyond the inner block then declare it in the outer block.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      if you do not want to use DBMS_OUTPUT , you need to define your own procedure for that purpose.

      Comment

      Working...