Skip to Content
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
book

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

by John Adolph Palinski
August 2002
Intermediate to advanced content levelIntermediate to advanced
528 pages
10h 12m
English
Addison-Wesley Professional
Content preview from Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Executing the PL/SQL Program

PL/SQL code blocks that are contained in an external file are called anonymous block procedures and can be executed from the SQL prompt by using the START keyword. The location and name of the file follow the START keyword. This keyword causes SQL*Plus to load, compile, and execute the code block contained in the file. Listing 14.2 illustrates the execution of the code block illustrated in Listing 14.1.

Listing 14.2. Executing a PL/SQL Program
SQL> start c:\business\oracle~1\plsql1\l1.sql 

HELLO 

PL/SQL procedure successfully completed 

End listing 

Upon completion of the PL/SQL code block, Oracle will output the message “PL/SQL procedure successfully completed,” which means that the program completed execution. If ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey

Publisher Resources

ISBN: 0201752948Purchase book