SQL*Plus does not run PL/SQL block

Question

I have a problem running my PL/SQL script in SQL*Plus. I can run SQL commands normally but when I want to a run any PL/SQL code it gives nothing. See code and output below.

screenshot

DECLARE
    x_salary employee.salary%TYPE;
BEGIN
    select salary
    into x_salary
    from employee
    where ssn=&enter_ssn;

    --Output the result
    DBMS_OUTPUT.PUT_LINE('Salary is ' || x_salary);

EXCEPTION
    --Output when no records are returned
    WHEN no_data_found THEN
        DBMS_OUTPUT.PUT_LINE ('No employee found');

    WHEN others THEN
        DBMS_OUTPUT.PUT_LINE ('Error encountered, but cause unknown');
END;

@BarbarosÖzhan - what do you mean by "in the command line"? The OP said this is a script - which means he is not running it interactively. The slash should come after END; on a new line, by itself. — user5683823
– user5683823, Commented Apr 12, 2020 at 21:17
@BarbarosÖzhan - ah, lol - no, I usually don't open images. But even so, the backslash rather belongs in the script, not after it... (I do see your point though.) — user5683823
– user5683823, Commented Apr 12, 2020 at 21:22

Derviş Kayımbaşıoğlu · Accepted Answer · 2020-04-12 21:17:02Z

6

PL/SQL procedures needs / after procedure definition under sqlplus

DECLARE
 ...
BEGIN
 ...
END;

/

answered Apr 12, 2020 at 21:17

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Derviş Kayımbaşıoğlu Over a year ago

If this answer is helpful for you, please consider to mark it as answer. Thanks

Lalit Kumar B · Accepted Answer · 2020-04-12 21:57:12Z

2

Put a slash / in a new line after END; in your script.

From the documentation:

You must include a semicolon at the end of each SQL command and a slash (/) on a line by itself after each PL/SQL block in the file.

Then execute the SQL file in SQL*Plus command line as:

@C:\your_script.sql;

edited Apr 12, 2020 at 21:57

answered Apr 12, 2020 at 21:25

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

Collectives™ on Stack Overflow

SQL*Plus does not run PL/SQL block

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related