{"id":610,"date":"2022-07-26T11:20:15","date_gmt":"2022-07-26T11:20:15","guid":{"rendered":"http:\/\/wp.chaoyu.nl\/?p=610"},"modified":"2022-07-26T14:04:48","modified_gmt":"2022-07-26T14:04:48","slug":"run-java-programs-in-plsql","status":"publish","type":"post","link":"https:\/\/chaoyu.nl\/?p=610","title":{"rendered":"Run Java Programs in plsql"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Java Class<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>login to db server <\/li><li>install java sdk <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-cyan-bluish-gray-color\"> <\/mark><mark style=\"background-color:#abb8c3\" class=\"has-inline-color has-black-color\"><code><em>sudo yum install java-1.8.0-openjdk<\/em><\/code><\/mark><\/strong>&#8216;<\/li><li>check  <strong><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\"><em>java -v<\/em><\/mark><\/code><\/strong><\/li><li><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\"><strong><em>mdkr myJavaFile<\/em><\/strong><\/mark><\/code><\/li><li><strong><em><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">nano Square_Cube.java<\/mark><\/code><\/em><\/strong><\/li><li><strong><em><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">javac <strong><em><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">Square_Cube<\/mark><\/code><\/em><\/strong>.java<\/mark><\/code><\/em><\/strong><\/li><li>it creates a new file <em><code>Square_Cube<\/code>.class<\/em><\/li><li><strong><em><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">loadjava -thin -user db_user\/db_pwd@localhost:1521\/xepdb1 -resolve -verbose <strong><em><code><mark style=\"background-color:#abb8c3\" class=\"has-inline-color\">Square_Cube<\/mark><\/code><\/em><\/strong>.class<\/mark><\/code><\/em><\/strong><\/li><li>this will create a new java class entry in your db<\/li><\/ol>\n\n\n\n<pre title=\"Content of Square_Cube.java file\" class=\"wp-block-code giveFontSize15 has-small-font-size\"><code lang=\"java\" class=\"language-java line-numbers\">public class Square_Cube{\n        public static int Square (int a ) {\n                return a*a;\n        }\n        public static int Cube (int b) {\n                return b*b*b;\n        }\n}<\/code><\/pre>\n\n\n\n<pre title=\"Create PLSQL function block to call java class\" class=\"wp-block-code giveFontSize15 has-small-font-size\"><code lang=\"sql\" class=\"language-sql line-numbers\">Create Or Replace Function square(a In Number) Return Number As\n   Language Java Name 'Square_Cube.Square(int) return int';\n\nCreate Or Replace Function Cube(b In Number) Return Number As\n   Language Java Name 'Square_Cube.Cube(int) return int';\n\nselect square(10) ,cube(10) from dual;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Java Source<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<pre title=\"create a new java source\" class=\"wp-block-code giveFontSize15 has-small-font-size\"><code lang=\"sql\" class=\"language-sql line-numbers\">CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED \"Hello\" AS\n  public class Hello{\n         public static String World(){\n                return \"Hello World!\";\n         }\n  };\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<pre title=\"create a plsql function block to call java source\" class=\"wp-block-code giveFontSize15 has-small-font-size\"><code lang=\"sql\" class=\"language-sql line-numbers\">Create Or Replace Function helloworld Return Varchar2 As\n   Language Java Name 'Hello.World () return java.lang.String';\n\/\n\nDeclare\n   v_string Varchar2(100 Char);\nBegin\n   v_string := helloworld();\n   \nEnd;\n\/\n\nSelect helloworld\nFrom   dual;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Java Class login to db server install java sdk sudo yum install java-1.8.0-openjdk&#8216; check java -v mdkr myJavaFile nano Square_Cube.java javac Square_Cube.java it creates a new file Square_Cube.class loadjava -thin -user db_user\/db_pwd@localhost:1521\/xepdb1 -resolve -verbose Square_Cube.class this will create a new java class entry in your db Java Source<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,10],"tags":[],"class_list":["post-610","post","type-post","status-publish","format-standard","hentry","category-oralce-db","category-pl-sql"],"_links":{"self":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=610"}],"version-history":[{"count":18,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":634,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions\/634"}],"wp:attachment":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}