create_javalib1.sql

介绍Oracle PL SQL编程

/*
 * create_javalib1.sql
 * Chapter 12, Oracle10g PL/SQL Programming
 * by Ron Hardman, Michael McLaughlin and Scott Urman
 *
 * This script demonstrates how to build a Java library
 * wrapper.
 */

SET ECHO ON
SET SERVEROUTPUT ON SIZE 1000000

CREATE OR REPLACE FUNCTION read_string
  (file IN VARCHAR2)
  RETURN VARCHAR2 IS
  LANGUAGE JAVA
  NAME 'ReadFile1.readString(java.lang.String) return String';
/