create_javalib1.sql

来自「介绍Oracle PL SQL编程」· SQL 代码 · 共 19 行

/*
 * 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';
/