I am new to pl/sql so this might be a silly question, I created a simple PL/SQL program:
DECLARE
inputData VARCHAR2(1024);
BEGIN
inputData :='&&inputData' ;
Dbms_Output.put_line('Value entered is:' || inputData);
END;
/
When I run this program, I am getting below output:
Enter value for inputdata: check
old 4: inputData :='&&inputData' ;
new 4: inputData :='check' ;
Value entered is:check
PL/SQL procedure successfully completed.
How can we get rid of lines for old and new values when the output is displayed.
simply set this (see the sqlplus user guide):
set verify off
at the top of your script.
SQL> set verify off
SQL> DECLARE
2 inputData VARCHAR2(1024);
3 BEGIN
4 inputData :='&&inputData' ;
5 Dbms_Output.put_line('Value entered is:' || inputData);
6 END;
7 /
Enter value for inputdata: sdf
PL/SQL procedure successfully completed.
SQL>
To disable :old and :new output use:
SET VERIFY OFF;
To disable update and other outputs:
SET FEEDBACK OFF;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With