Oracle Java Stored Procedure + 包调用
来源:互联网 发布:mac游戏推荐 编辑:程序博客网 时间:2024/04/28 18:39
1. 创建Java Stored Procedure
create or replace and compile java source named "TestHello" aspublic class TestHello{ public static void test(){ System.out.println("Hello"); }}
2.创建JSP调用存过或方法(本例为在包创建的存过)
create or replace package pkg_test is procedure do_Test;end pkg_test;/create or replace package body pkg_test is procedure do_Test as language java name 'TestHello.test()';begin null;end pkg_test;/
3.在命令窗口调用,通过如下命令使System.out重定向到当前窗口
SQL> set serveroutput onSQL> call dbms_java.set_output(5000);Method calledSQL> exec pkg_test.do_Test;HelloPL/SQL procedure successfully completed
0 0
- Oracle Java Stored Procedure + 包调用
- Oracle Java Stored Procedure调用Unix shell
- Java: Passing Array to Oracle Stored Procedure
- Java: Passing Array To Oracle Stored Procedure
- oracle, stored procedure, cursor
- Oracle Stored Procedure example
- oracle 存储过程 stored procedure 查询记录(带包)
- Java - Stored Procedure OUT Parameter
- java 调用 oracle 中procedure
- Oracle 中调用Java Stored Procedures
- YIi调用mysql的stored procedure
- pass blob to oracle stored procedure
- Get Dataset from Stored Procedure in Oracle
- Stored Procedure
- java 调用ORACLE的PROCEDURE 注意事项
- Hibernate 调用带有复合主键的stored procedure
- Hibernate 调用带有复合主键的stored procedure
- 关于存储过程的重复调用 about Stored Procedure
- Linux常见命令之crontab
- HDU 1513 Palindrome DP
- 【行业参考】大数据背景下的淘宝核心数据库建设与OceanBase技术探讨
- 配置Apache实现url转发
- 应用Python解决报表日常对数问题
- Oracle Java Stored Procedure + 包调用
- python+Eclipse+pydev环境搭建
- String 按引用传递和数组按引用传递浅见
- About Module and Package in Python
- iOS 平台项目接入新浪微博 SDK 的坑
- Android客户端+JavaEE后台服务器端+Mysql数据库(社交app-心情驿站)
- UVa 208 - Firetruck
- Windows下FFmpeg调试
- I/O端口和IO内存