Updated the Basic Samples Readme

Kuassim · Kuassim · commit 148ac4bb1792 · 2018-07-24T17:42:35.000-07:00
diff --git a/java/jdbc/BasicSamples/JavaStoredProcSample.sql b/java/jdbc/BasicSamples/JavaStoredProcSample.sql
@@ -0,0 +1,32 @@
+Rem JavaStoredProcSample.sql
+Rem
+Rem Copyright (c) 2018, Oracle and/or its affiliates. All rights reserved.
+Rem
+Rem    NAME
+Rem      JavaStoredProcSample.sql
+Rem
+Rem    DESCRIPTION
+Rem      This SQL script is for creating a wrapper for a java stored procedure; 
+REm      then calls it and displays the output.
+
+REM 
+REM Wrapper (a.k.a. Call Spec) for invoking JavaStoredProcSample.getEmpCountByDept(int) 
+REM 
+
+CREATE OR REPLACE FUNCTION GET_EMP_COUNT_BY_DEPT (dept_no NUMBER)
+   RETURN NUMBER AS LANGUAGE JAVA
+   NAME 'JavaStoredProcSample.getEmpCountByDept(int) return int';
+/
+
+REM 
+REM Enable the output of GET_EMP_COUNT_BY_DEPT() then invoke it. 
+REM 
+
+set echo on 
+set serveroutput on size 5000 
+call dbms_java.set_output (5000); 
+
+VARIABLE v NUMBER;
+CALL GET_EMP_COUNT_BY_DEPT(20) INTO :v;
+PRINT v
+
diff --git a/java/jdbc/BasicSamples/Readme.md b/java/jdbc/BasicSamples/Readme.md
@@ -49,6 +49,8 @@ but, will hit error when connecting as these are dummy values.
 * **UCPMaxConnReuse.java**: Shows how applications use the MaxConnectionReuseTime and MaxConnectionReuseCount features of UCP. 
 * **UCPMultiUsers.java**: Shows how JDBC applications use UCPP to pool connections for different users.
 * **UCPTimeouts.java**: Shows key connection timeout features of UCP such as ConnectionWaitTimeout, InactiveConnectionTimeout, TimeToLiveConnectionTimeout, and AbandonedConnectionTimeout.
+* **JavaStoredProcSample.java**: Shows a basic Java stored procedure.
+* **JavaStoredProcSample.sql**: Shows how to create a wrapper for a Java stored procedure and execute it.
      
 
 
