CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Sms3" AS

import java.io.IOException;
import java.io.BufferedReader;
import java.io.DataOutputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.nio.charset.StandardCharsets;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;


public class Sms3 {
	
	public static void main(String[] args) throws Exception {
            new Sms3().sendSms();
        }
        
        public static String sendSms() throws Exception {
                String V_RESULT = "";

		DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Calendar cal = Calendar.getInstance();
		    
		String pubKey = "публичный ключ"; //Public Key
		String prtKey = "приват ключ"; //Private Key
		String sender = "наименование"; //Sender Name
		String datetime = dateFormat.format(cal.getTime()); //DateTime
		String phone = "номер телефона"; //Phone number
		String message2 = "текст смс"; //message text
		try{
			
			String hash = getHash(pubKey+phone+sender+message2+datetime+prtKey, "MD5"); // get to hash
		
			URL url = new URL("URL-адрес");
			HttpURLConnection conn =(HttpURLConnection) url.openConnection();
			
			String urlParameters = "hash="+hash+"'&'sender="+sender+"'&'message="+message2+"'&'datetime="+datetime+"'&'publicKey="+pubKey+"'&'phone="+phone+"";
			byte[] postData = urlParameters.getBytes( StandardCharsets.UTF_8 );
			int postDataLength = postData.length;
			
			conn.setDoOutput(true);
			conn.setInstanceFollowRedirects( false );
			conn.setRequestMethod("POST");
			conn.setRequestProperty( "Content-Type", "application/x-www-form-urlencoded");
			conn.setRequestProperty( "charset", "utf-8");
			conn.setRequestProperty( "Content-Length", Integer.toString( postDataLength ));
			conn.setUseCaches( false );
			
                        DataOutputStream wr = new DataOutputStream( conn.getOutputStream());
                        wr.write( postData );
                        wr.flush();
			
			if(conn.getResponseCode() != 200){
				throw new RuntimeException("Failed : HTTP error code : "+conn.getResponseCode());
			}
			BufferedReader br = new BufferedReader(new InputStreamReader((conn.getInputStream())));
			String output;
			
			//System.out.println("Output from Server... \n");
			while ((output = br.readLine()) != null) {
				//System.out.println(output);
                                V_RESULT = V_RESULT + output;
			}
			
			conn.disconnect();
		}catch(MalformedURLException e){
			e.printStackTrace();
		}catch (IOException e) {
			e.printStackTrace();

		  }
            //System.out.println(V_RESULT);
            return V_RESULT;
	}
        
        private static String getHash(String txt, String hashType) {
        try {
                    java.security.MessageDigest md = java.security.MessageDigest.getInstance(hashType);
                    byte[] array = md.digest(txt.getBytes());
                    StringBuffer sb = new StringBuffer();
                    for (int i = 0; i < array.length; ++i) {
                        sb.append(Integer.toHexString((array[i] & 0xFF) | 0x100).substring(1,3));
                 }
                    return sb.toString();
            } catch (java.security.NoSuchAlgorithmException e) {
                //error action
            }
            return null;
        }

        private static String md5(String txt) {
            return getHash(txt, "MD5");
        }

        private static String sha1(String txt) {
            return getHash(txt, "SHA1");
        }
	
}

CREATE OR REPLACE FUNCTION smsSendFunc3
RETURN VARCHAR2
AS
  LANGUAGE JAVA NAME 'Sms3.sendSms() return java.lang.String';

select smsSendFunc3 from dual;

ORA-29541: class FORS.Sms3 could not be resolved

SQL> SET SERVEROUTPUT ON SIZE 1000000;
SQL> CALL DBMS_JAVA.SET_OUTPUT (1000000);

Method called

SQL> exec dbms_output.put_line(smsSendFunc3());

}
        
        public static String sendSms() throws Exception {
                String V_RESULT = "";

String urlParameters = "hash="+hash+"'&'sender="+sender+"'&'message="+message2+"'&'datetime="+datetime+"'&'publicKey="+pubKey+"'&'phone="+phone+"";

ORA-01741: illegal zero-length identifier

ORA-00900: invalid SQL statement

SELECT * FROM user_objects t
where t.object_name='Sms3'

select * from user_errors where name = 'Sms3';

NAME	TYPE	SEQUENCE	TEXT
Sms3	JAVA CLASS	1	ORA-29535: source requires recompilation
Sms3	JAVA SOURCE	1	Sms3:8: cannot resolve symbol
Sms3	JAVA SOURCE	2	symbol  : class StandardCharsets 
Sms3	JAVA SOURCE	3	location: package charset
Sms3	JAVA SOURCE	4	import java.nio.charset.StandardCharsets;
Sms3	JAVA SOURCE	5	                        ^
Sms3	JAVA SOURCE	6	Sms3:40: cannot resolve symbol
Sms3	JAVA SOURCE	7	symbol  : variable StandardCharsets 
Sms3	JAVA SOURCE	8	location: class Sms3
Sms3	JAVA SOURCE	9	"			byte[] postData = urlParameters.getBytes( StandardCharsets.UTF_8 );"
Sms3	JAVA SOURCE	10	                                                                  ^
Sms3	JAVA SOURCE	11	2 errors