CODEWITHSUNDEEP
oracle-database
Happy Torturer
Happy Torturer

Reputation: 1138

Oracle 10g. Errors with calling procedures

I'm trying to run simple procedures and functions but get the same sort of error (Oracle 10g). What's wrong here?

CREATE OR REPLACE PROCEDURE hello_world
IS
  l_message
  VARCHAR2 (100) := 'Hello World!';
BEGIN
  DBMS_OUTPUT.put_line (l_message);
END hello_world;
/

BEGIN
   hello_world;
END;
/

Error message:

ERROR at line 9: PLS-00103: Encountered the symbol "/" 
7.   DBMS_OUTPUT.put_line (l_message);
8. END hello_world;
9. /
10. BEGIN
11.    hello_world;

Upvotes: 0

Views: 36

Answers (1)

Guneli
Guneli

Reputation: 1721

The problem is that you are executing all of this code together. You should first execute create or replace procedure part and after the procedure is created, execute an anonymuous block:

BEGIN
   hello_world;
END;
/

Upvotes: 1

Related Questions