# HG changeset patch # User Oleksandr Gavenko # Date 1507545432 -10800 # Node ID 60f74f8b5967b17d5dc03d5c08bb8fc4dd64bcde # Parent 493d19cc34e18b3d0b3b82c693128f8a749ed051 Call procedure/function. diff -r 493d19cc34e1 -r 60f74f8b5967 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. ==============