# Oracle function using Java code

**URL:** <https://www.batmunkh.net/t/oracle-function-using-java-code/849>\
**Category:** Oracle Database\
**Created:** [September 19, 2018, 3:10am UTC](https://www.batmunkh.net/t/oracle-function-using-java-code/849 "2018-09-19T03:10:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![booboo](https://www.batmunkh.net/user_avatar/www.batmunkh.net/booboo/32/305_2.png) [@booboo](https://www.batmunkh.net/u/booboo)\
**Post date:** [September 19, 2018, 3:10am UTC](https://www.batmunkh.net/t/oracle-function-using-java-code/849/1 "2018-09-19T03:10:59Z")

</div>

Сайн байцгаана уу.

Stored Procedure, Function дээр жава кодыг хэрхэн ашигласан туршлагаасаа хуваалцъя гэж бодлоо. Уг асуудлыг шийдэх гээд хайж байгаа нэгэнд хэрэг болж магад

**Алхам 1:** Ашиглах жава кодоо бэлдэх. Миний хувьд Procedure-c URL руу GET болон json POST илгээх шаардлага гарсан. /Example: GET and POST бичсэн кодоо _.java_ өргөтгөлтэй file болгон хадгална/

import java.io.BufferedReader;  
import java.io.DataOutputStream;  
import java.io.InputStreamReader;  
import java.net.HttpURLConnection;  
import java.net.URL;

```
    public class CallHttpFunction {
        
        public static String getAction(String _url) {
    	String resultVal = "";
    	try
    	{
                URL obj = new URL(_url);
                HttpURLConnection con = (HttpURLConnection) obj.openConnection();
                con.setRequestMethod("GET");
                BufferedReader in = new BufferedReader( new InputStreamReader(con.getInputStream()));
                String inputLine;
                StringBuffer response = new StringBuffer();
                while ((inputLine = in.readLine()) != null) {
    		response.append(inputLine);
    		}
                in.close();
                resultVal = response.toString();
    	}
    	catch(Exception ex)
    	{
                resultVal = "ERROR: " + ex.getMessage();
    	}
    	return resultVal;   
        }
        
        public static String postAction(String _url, String _json){
            String resultVal = "";
            try
    		{
    			URL obj = new URL(_url);
    			HttpURLConnection conn = (HttpURLConnection) obj.openConnection();
    			conn.setDoOutput(true);
    			conn.setRequestMethod("POST");
    			conn.setRequestProperty("Content-Type", "application/json");
    			String input = _json;
    			DataOutputStream wr = new DataOutputStream(conn.getOutputStream());
    			wr.writeBytes(input);
    			wr.flush();
    			wr.close();
    			BufferedReader in = new BufferedReader(
    		        new InputStreamReader(conn.getInputStream()));
    			String inputLine;
    			StringBuffer response = new StringBuffer();
    			while ((inputLine = in.readLine()) != null) {
    				response.append(inputLine);
    			}
    			in.close();
    			resultVal = response.toString();
    		}
    		catch(Exception ex)
    		{
    			resultVal = "ERROR: " + ex.getMessage();
    		}
            return resultVal;
        }
    }

```

**Алхам 2:** Кодоо бааз руу хуулах. /Би java кодоо dmpdir дотороо хуулж байгаад load хийсэн./

1. Windows дээр upload хийх. " loadjava -user _user\_name/password_ -verbose _filePath_ "  
 ![winLoadjava](https://www.batmunkh.net/uploads/default/original/1X/75b9a92b9ad4bc6ff42cd3f43a3be4ef895b68ea.png)
2. Linux дээр upload хийх.  
 ![LinuxLoadjava](https://www.batmunkh.net/uploads/default/original/1X/9f682b49ef976e13917d5f4195c1e3c723228ee9.png)

Load хийгдсэн java маань дараах байдалтай харагдана.

 ![loadedJava](https://www.batmunkh.net/uploads/default/original/1X/aa19bd7c2db7a2617e215e034f1fd38c88d6e925.png)

**Алхам 3:** Create Oracle Function

1. GET  
create or replace FUNCTION getUrl(pUrl VARCHAR2) RETURN VARCHAR2 AS  
LANGUAGE JAVA NAME ‘CallHttpFunction.getAction(java.lang.String) return java.lang.String’;
2. POST  
create or replace FUNCTION postUrl(pUrl VARCHAR2, pJson VARCHAR2) RETURN VARCHAR2 AS  
LANGUAGE JAVA NAME ‘CallHttpFunction.postAction(java.lang.String, java.lang.String) return java.lang.String’;

Үр дүн:

 ![result](https://www.batmunkh.net/uploads/default/original/1X/c920e30ca6bc4912ebfd8ce4eaf172d38ba756d5.png)

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [September 19, 2018, 6:44am UTC](https://www.batmunkh.net/t/oracle-function-using-java-code/849/2 "2018-09-19T06:44:21Z")

</div>

Сайхан цэгцтэй мэдээлэл байна… 👍👋👌👓
