PL/SQL Procedure compiled with errors

Question

I am a newbie to PL/SQL. This is the block I executed :

SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE DoctorandNurse (id number, name varchar2, dno number, timings varchar2, contact number, gender char, email varchar2, salary number, doj date, post varchar2) AS
salary_exception EXCEPTION;
BEGIN
IF salary >= 2500000 THEN raise salary_exception;
ELSE
insert into Doctor_Nurse values(id,name,dno,timings,contact,gender,email,salary,doj,post);
END IF;
EXCEPTION
WHEN salary_exception THEN DMS_OUTPUT.PUT_LINE('Salary should be less than or equal to Rs. 25,00,000.');
END;

The compiler reported that the procedure was created with compilation error. What is the error exactly. Please ask for additional information if required.

Please issue the command, show errors, and provide the results. — Patrick Bacon
– Patrick Bacon, Commented Nov 29, 2017 at 18:31
This is the error as i said before : Procedure created with compilation error. Nothing more, nothing less. — Tanmay Bhatnagar
– Tanmay Bhatnagar, Commented Nov 29, 2017 at 18:32

Andrei Nossov · Accepted Answer · 2017-11-29 18:47:18Z

3

If you're using SQL*Plus, the following will work:

SQL> sho err

Not sure about the rest of clients, but most should support this syntax.

answered Nov 29, 2017 at 18:47

Andrei Nossov

1014 bronze badges

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

1 Comment

Tanmay Bhatnagar Over a year ago

This fixed the problem once I saw the error. The error was a syntactical error. DBMS._OUTPUT.PUT_LINE. I missed the B.

Collectives™ on Stack Overflow

PL/SQL Procedure compiled with errors

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related