#pragma section-numbers off [[TableOfContents]] = 概要 = ["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 [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]