Call web service from Java
import java.net.*; import java.io.*; public class EDCJavaWSInterface { public static double GetTicketBalance(String aimsServer, String ticketId) throws IOException { // initialize the connection …
Convert integer to string Java
String stringInt = "999999999"; int i = Integer.parseInt(stringInt); System.out.println("Integer: " + i);
TSQL convert int to string
–Converts an int to a string SELECT CONVERT ( varchar , intcolumn ) FROM TABLE
Determine Available Java Packages in Oracle
select dbms_java.longname(object_name), status, object_type from all_objects where object_name like ‘%javax%’ and object_type = ‘JAVA CLASS’;
Get Java Version from Java
public class myGetVersion { public static String getVersion() { return System.getProperty("java.version"); } }
Call Java from PLSQL
1). Create a Java class public class EDCTest1 { public static String getsometext() { return "this is test text"; } } 2). Load the class …
Consuming Web Services Oracle PL/SQL
http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php
PL/SQL Exceptions
http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/07_errs.htm
Determine Oracle Version
select * from v$version where banner like ‘Oracle%’;