Call procedure/function.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Mon, 09 Oct 2017 13:37:12 +0300
changeset 2194 60f74f8b5967
parent 2193 493d19cc34e1
child 2195 3556ec0e48be
Call procedure/function.
oracle.rst
--- 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.
 ==============