Mega Code Archive
This is an anonymous procedure, so it has no name
<![CDATA[
SQL> declare
2 /*
3 declare local cursors, variables, and methods here,
4 but you don't need to have a declaration section.
5 */
6 begin
7 -- You write your logic here
8
9 null; -- Ahhh, you've got to have at least one command!
10 exception
11 when NO_DATA_FOUND then
12 raise_application_error(-20000, 'Hey, No Data Found!');
13 end;
14 /
PL/SQL procedure successfully completed.
SQL>
]]>