SQL>  create or replace procedure test_this_man as
  2   a varchar2(100);
  3   begin
  4     dbms_output.put_line ('Test');
  5     a := 'AAA&DDDD';
  6     dbms_output.put_line (a);
  7* end;
SQL> /
Enter value for dddd: dd
old   5:    a := 'AAA&DDDD';
new   5:    a := 'AAAdd';
Warning: Procedure created with compilation errors.
To avoid this Error set the scan to off:-
sql> set scan off;
SQL>  create or replace procedure test_this_man as
  2   a varchar2(100);
  3   begin
  4     dbms_output.put_line ('Test');
  5     a := 'AAA&DDDD';
  6     dbms_output.put_line (a);
  7*  end;
SQL> /
Procedure created.
SQL> set serveroutput on;
SQL> exec test_This_man
Test
AAA&DDDD
 
No comments:
Post a Comment