--- a/oracle.rst Mon Oct 09 13:07:50 2017 +0300
+++ b/oracle.rst Mon Oct 09 13:37:12 2017 +0300
@@ -27,7 +27,7 @@
Oracle Reports is a tool for developing reports against data
stored in an Oracle database.
-Useful PL/SQL stub.
+Useful PL/SQL stubs
===================
::
@@ -57,6 +57,34 @@
exec DBMS_OUTPUT.PUT_LINE('Silence');
exec DBMS_OUTPUT.ENABLE();
+Call procedure::
+
+ create or replace procedure MY_PROC as
+ begin
+ null;
+ end;
+ /
+
+ begin
+ MY_PROC;
+ end;
+ /
+
+Call function::
+
+ create or replace function MY_FUN return number as
+ begin
+ return 42;
+ end;
+ /
+
+ declare
+ x NUMBER;
+ begin
+ ret := MY_FUN();
+ end;
+ /
+
Database info.
==============