How To Define an Anonymous Procedure without Variables


How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions



Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script:

SQL> set serveroutput on;

SQL> begin 
  2    dbms_output.put_line('Welcome to FYICenter!'); 
  3  end;
  4  /
Welcome to FYICenter!

PL/SQL procedure successfully completed.

"set serveroutput on;" allows dbms_output.put_line() to work.

"/" runs the anonymous block, which print the "Welcome to FYICenter!" message.

2007-04-26, 4556👍, 0💬