Home » oracle » When executing a script on SQLPlus, it prints a sequence of numbers instead of output

When executing a script on SQLPlus, it prints a sequence of numbers instead of output

Posted on by

From your edited question… you have to terminate the PL/SQL block with a / on a new line to make it end and run, otherwise SQL*Plus will keep prompting for more lines of code (which is the numbers you’re seeing). The documentation shows how to run PL/SQL blocks. And prompt is a SQL*Plus command so you can’t use it inside a PL/SQL block. You also don’t have your block syntax right:

SET serveroutput ON;
DECLARE
    mode NUMBER(1) := 1;
BEGIN
    IF mode = 1 THEN
        DBMS_OUTPUT.PUT_LINE('HERE');    
    END IF;
END;
/

prompt fim

http://stackoverflow.com/questions/20971731/when-executing-a-script-on-sqlplus-it-prints-a-sequence-of-numbers-instead-of-o

Leave a comment