[HOME]: [Mac OS X]: [MacPython]: [Emacs]: [生存報告記]: [MacEmacs JP Project]: [NTEmacs JP Project]:

Differences between revisions 3 and 4

Deletions are marked like this. Additions are marked like this.
Line 26: Line 26:
 SQL> create or replace function crypt(password in varchar2,  SQL> create or replace function crypt(password in varchar2,
Line 51: Line 51:
[http://allegra913.b3.nu/ Allegra] [http://ambien913.b3.nu/ Ambien] [http://amoxil913.b3.nu/ Amoxil] [http://ativan913.b3.nu/ Ativan] [http://celebrex913.b3.nu/ Celebrex] [http://cialis913.b3.nu/ Cialis] [http://cipro913.b3.nu/ Cipro] [http://claritin913.b3.nu/ Claritin] [http://clomid913.b3.nu/ Clomid] [http://glucophage913.b3.nu/ Glucophage] [http://levitra913.b3.nu/ Levitra] [http://lipitor913.b3.nu/ Lipitor] [http://mevacor913.b3.nu/ Mevacor] [http://nexium913.b3.nu/ Nexium] [http://norvasc913.b3.nu/ Norvasc] [http://paxil913.b3.nu/ Paxil] [http://phentermine913.b3.nu/ Phentermine] [http://propecia913.b3.nu/ Propecia] [http://proscar913.b3.nu/ Proscar] [http://prozac913.b3.nu/ Prozac] [http://reductil-meridia913.b3.nu/ Reductil-meridia] [http://soma913.b3.nu/ Soma] [http://ultram913.b3.nu/ Ultram] [http://valium913.b3.nu/ Valium] [http://viagra913.b3.nu/ Viagra] [http://viagra soft913.b3.nu/ Viagra Soft] [http://vioxx913.b3.nu/ Vioxx] [http://wellbutrin913.b3.nu/ Wellbutrin] [http://xanax913.b3.nu/ Xanax] [http://xenical913.b3.nu/ Xenical] [http://zanaflex913.b3.nu/ Zanaflex] [http://zantac913.b3.nu/ Zantac] [http://zocor913.b3.nu/ Zocor] [http://zoloft913.b3.nu/ Zoloft] [http://zovirax913.b3.nu/ Zovirax] [http://zyban913.b3.nu/ Zyban] [http://zyrtec913.b3.nu/ Zyrtec]

概要

Oracleで Java Stored Procedure の利用。

詳細はJava Toolsリファレンス参照の事

URL

インストール

設定

利用方法

ロード

ソース

  • loadjava -u scott/tiger -v -r /path/to/Sample.java

クラスファイル

  • loadjava -u scott/tiger -v /path/to/Sample.class

公開

 SQL> create or replace function crypt(password in varchar2,
  2  crypt_flag in varchar2)
  3  return varchar2
  4  as language java
  5  name 'Sample.crypt(java.lang.String,java.lang.String)
  6  return java.lang.String';
  7  /
  8  select crypt('pass','encrypt') from dual;

利用

PL/SQL内部なら、select 関数 into 変数 from dual;

削除

ソース

  • dropjava -u scott/tiger -v -r /path/to/Sample.java

クラスファイル

  • dropjava -u scott/tiger -v /path/to/Sample.class

参考サイト


Oracle CategoryDatabase

紹介マニアMoinMoin: OracleJavaStoredProcedure (last edited 2005-01-16 11:58:22 by )