Creating Procedures with IN and OUT Parameters

JDBC Tutorials - Herong's Tutorial Notes

Dr. Herong Yang, Version 2.11

JDBC Tutorials - Herong's Tutorial Notes

∟Oracle - JBDC CallableStatement

∟Creating Procedures with IN and OUT Parameters

This section describes how to create a procedure with IN and OUT parameters.

To do more tests on CallableStatement objects, I created another stored procedure with IN and OUT parameters:

C:\>sqlplus
Enter user-name: Herong/TopSecret

SQL> -- Creating a stored procedure
SQL> CREATE PROCEDURE CountChar(String IN CHAR, 
  2    Count OUT INTEGER) AS
  3  BEGIN
  4    Count := LENGTH(String);
  5  END;
  6  /

Procedure created.

SQL> -- Turning on server output for PUT_LINE()
SQL> SET SERVEROUTPUT ON;

SQL> -- Testing the procedure with an anonymous procedure
SQL> DECLARE
  2    C INTEGER;
  3  BEGIN
  4    CountChar('Herong',C);
  5    DBMS_OUTPUT.PUT_LINE('Count: ' || C);
  6  END;
  7  /
Count: 6

PL/SQL procedure successfully completed.

Note that I had to use an anonymous procedure to test CountChar(), because the output variable needs to be declared.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

Downloading and Installing JDK - Java SE

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows