`

oracle:java stored procedure or function

阅读更多
--java source hasn't return value
create or replace and compile java source named TestJava1 as
public class TestJavaHank1
{
  public static void entry()
  {
         System.out.println("I am maxiaohu!");
  }
}
--java source has return value
create or replace and compile java source named TestJava2 as
public class TestJavaHank2
{
  public static String entry(String name)
  {    
         return "你好:"+name;
  }
}

create or replace procedure testjava as language java name 'TestJavaHank.entry()';

create or replace function testjava2(name varchar2) return varchar2
as language java name 'TestJavaHank2.entry(java.lang.String) return java.lang.String';

--在oracle中加载编译过的class文件
create or replace function testCode(name varchar2) return varchar2
as language java name 'test.getCode(java.lang.String) return java.lang.String';

--外部java类   启动enterprise manageconsole,
--在“方案”下找到“源类型”,右击”java类”,
--选择”加载java“,选择对应的class文件即可。
          public class test
          {
          public static String getCode(String name)
          {
          return "123"+name;
          }
         
          }


--call procedure
begin
testjava;
end;

--command window
SET SERVEROUTPUT ON;  
CALL dbms_java.set_output(2000); 
exec testjava;

--call function
begin
dbms_output.put_line(testCode('maxiaohu'));
end;
分享到:
评论

相关推荐

    Navicat Premium 11.0.10

    Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...

    SQL Assistant v5.0

    Code refactoring - Extract sub procedure definition from procedural code - 3 clicks method for conversion of a block of code to a stored procedure or function - customizable templates. Code ...

    PremiumSoft Navicat Premium Enterprise v11.2.13 (x86 & x64)

    SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. Navicat Premium enables you to easily and quickly transfer data across various database ...

    Tibero 6_Administrator's Guide_v2.1.7_en.pdf

    tibero6 數據管理手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成

    Tibero 6_Installation Guide_v2.1.7_en.pdf

    tibero6 數據庫安裝手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成

    Oracle sqldeveloper without jdk (win+linux)

    Values to which NCHAR, NVARCHAR2, or NCLOB columns are modified may be unnecessarily converted to the database character set before being converted to the national character set and stored in the ...

    Tibero 6_Hadoop Connector Guide

    tibero6 數據庫連接大數據手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成

    Navicat 11.2.12 Premium x64

    Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...

    Navicat Premium Enterprise Edition v10.0.10 + Keygen

    Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...

    用ASP实现对ORACLE数据库的操作

    但对应用更加广泛、机制更加复杂的ORACLE 数据库服务就有一些困难,如果想作一些简单的查询功能,ADO是足够的,如要想更好地发挥ORACLE数据库特有的功能,如STORED PROCEDURE,STORED FUNCTION等就要采取利用ASP...

    Delphi7.1 Update

    * Using collections containing component references and form inheritance can result in incorrect references being stored in the dfm file.======================================================= CORE ...

    spring-framework-reference4.1.4

    3.3. Java 8 (as well as 6 and 7) ............................................................................... 17 3.4. Java EE 6 and 7 ..................................................................

    spring-framework-reference-4.1.2

    3.3. Java 8 (as well as 6 and 7) ............................................................................... 17 3.4. Java EE 6 and 7 ..................................................................

Global site tag (gtag.js) - Google Analytics