Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to disable old and new value option in output when I run PL/SQL program

Tags:

plsql

sqlplus

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.

like image 319
Chaitanya Avatar asked Mar 27 '13 15:03

Chaitanya


2 Answers

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>
like image 119
DazzaL Avatar answered Oct 11 '22 23:10

DazzaL


To disable :old and :new output use:

SET VERIFY OFF;

To disable update and other outputs:

SET FEEDBACK OFF;
like image 20
sbrbot Avatar answered Oct 11 '22 22:10

sbrbot