SQL Multiple Functions in One SQL File

Question

I have a question regarding defining two functions back to back with PL/SQL. Below is the code I have:

create or replace procedure test2(mynum in integer, retnum out integer)
as
begin
    DBMS_OUTPUT.put_line(mynum + 1);
    retnum := 1000;
end;



create or replace procedure test3(mynum in integer, retnum out integer)
as
begin
    DBMS_OUTPUT.put_line(mynum + 1);
    retnum := 1000;
end;

When I run it I get the following error, but when I create the functions separately I do not. Am I missing some keyword to separate the two declarations?

Procedure TEST2 compiled

LINE/COL ERROR

10/1 PLS-00103: Encountered the symbol "CREATE" Errors: check compiler log

rextester.com/LZFQFA22750 check the link i ran it and works properly — Zaynul Abadin Tuhin
– Zaynul Abadin Tuhin, Commented Oct 7, 2018 at 2:01
I'm guessing that you're using SQLPlus as your database client. Add a / on a line by itself after the END; for each procedure. Best of luck. — Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні, Commented Oct 7, 2018 at 2:03
You need a delimiter between the two functions. As @BobJarvis said, it should be a /. — Nick
– Nick, Commented Oct 7, 2018 at 2:15

Miroslav Duník · Accepted Answer · 2018-10-08 07:05:58Z

4

After every PL/SQL statement you should properly end it by adding / on a separate line as this is the "master delimiter".

Try to save your script as this:

create or replace procedure test2(mynum in integer, retnum out integer)
as
begin
    DBMS_OUTPUT.put_line(mynum + 1);
    retnum := 1000;
end;
/

create or replace procedure test3(mynum in integer, retnum out integer)
as
begin
    DBMS_OUTPUT.put_line(mynum + 1);
    retnum := 1000;
end;
/

answered Oct 8, 2018 at 7:05

Miroslav Duník

6063 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

SQL Multiple Functions in One SQL File

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related