1 2 Previous Next 16 Replies Latest reply: Jan 9, 2013 3:16 AM by 983133 Go to original post RSS
      • 15. Re: Learning to use Bind variables in a DML stainside an anonymous block
        Etbin
        Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
        PL/SQL Release 11.2.0.2.0 - Production
        CORE     11.2.0.2.0     Production
        TNS for Linux: Version 11.2.0.2.0 - Production
        NLSRTL Version 11.2.0.2.0 - Production
        case 1
        declare
          x number(10);
          y number(10);
        begin
          :x := 100;  /* with : */
          dbms_output.put_line('x = '||to_char(x));
          y := :x;
          dbms_output.put_line('y = '||to_char(y));
        end;
        
        Error at line 1
        ORA-06502: PL/SQL: numeric or value error: character string buffer too small
        ORA-06512: at line 5
        case 2
        declare
          x number(10);
          y number(10);
        begin
          x := 100;  /* without : */
          dbms_output.put_line('x = '||to_char(x));
          y := :x;
          dbms_output.put_line('y = '||to_char(y));
        end;
        
        PL/SQL procedure successfully completed.
        
        x = 100
        y =
        Regards

        Etbin
        • 16. Re: Learning to use Bind variables in a DML stainside an anonymous block
          983133
          Thanks. The problem is limited to the front end that i am using i.e. SQLDEVELOPER. Thanks.
          1 2 Previous Next