oracle.rst
changeset 2194 60f74f8b5967
parent 2185 f31a1ff8d8d9
child 2216 303e4963ffc5
--- 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.
 ==============