Tom:

One DBA is saying that. Can this be true??

In Oracle 9.0.1, Oracle won't support:

CORBA;
Enterprise Java Beans (EJB);
Oracle Server Java Pages;
Oracle Servlet Engine.

Hi Tom,
 I am trying to run java data bean inside database(very small code ) .. I am trying to create Constructor in java stored procedure but it's giving me error.

Can you help please. Here is the code...

  1  CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Siebel_SconnAddr_delete" AS
  2  import com.siebel.data.*;
  3  import com.siebel.data.SiebelException;
  4  import java.util.*;
  5  import java.io.*;
  6  import java.sql.*;
  7  import java.math.*;
  8  import oracle.sql.*;
  9  import oracle.jdbc.driver.*;
 10  public class Siebel_SconnAddr_delete
 11  {
 12    public static SiebelDataBean siebelDataBean;
 13     Public void Siebel_SconnAddr_delete()
 14    {
 15       siebelDataBean = new SiebelDataBean();
 16       siebelDataBean.login("siebel.TCPIP.None.None://cwppd003:2320/siebelent/eMediaObjMgr_enu/siebel
 17             "sadmin", "sadmin", "enu");
 18    }
 19  public static void Siebel(oracle.sql.ARRAY p_in) throws java.sql.SQLException,IOException
 20   {
 21  try {
 22          String[] values = (String[])p_in.getArray();
 23          siebelDataBean.traceOn("d:\\sea752\\siebsrvr\\log\\abc.txt","SQL","");
 24          SiebelService myService   = siebelDataBean.getService("DeleteAddressRecord");
 25          SiebelPropertySet myInput = siebelDataBean.newPropertySet();
 26          SiebelPropertySet myOutput = siebelDataBean.newPropertySet();
 27          for( int i = 0; i < p_in.length(); i++ ) {
 28          System.out.println( "p_in["+i+"] = " + values[i] );
 29          myInput.setProperty("Id", values[i]);
 30          myService.invokeMethod("DeleteRecord",myInput,myOutput);
 31          String Out_prop = myOutput.getProperty("ErrorMsg");
 32          System.out.println( "Output ["+ values[i] +"] = " + myOutput.getProperty("ErrorMsg") );
 33          }
 34          myService.release();
 35          siebelDataBean.traceOff();
 36      }
 37         catch (SiebelException e) {
 38          System.out.println("Error#: " + e.getErrorCode());
 39          System.out.println("Error Message: " + e.getErrorMessage());
 40         }
 41      }
 42* }
SQL> /
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Siebel_SconnAddr_delete" AS
                                                *
ERROR at line 1:
ORA-29536: badly formed source: Encountered "void" at line 12, column 11.

Was expecting one of:

<IDENTIFIER> ...

"[" ...

"." ...

"(" ...



SQL> 


Thanks 

Hi Tom,
We are using siebel java data bean from oracle java stored procedure to call siebel business object and business components.

I am trying to use java constructor approch in logging into siebel application. First session would initilize the constructor and create siebel session when I execute java stored procedure first time from Sql*Plus and subsequent session(stored procedure execution) will use already open connection to connect to siebel.

But looks like constructor approch is not working from java stored procrdure..(It's working from JDK)

Can you please help here?.. Thanks


CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Siebel_SconnAddr_delete" AS import com.siebel.data.*;
import com.siebel.data.SiebelException;
import java.util.*;
import java.io.*;
import java.sql.*;
import java.math.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;
public class Siebel_SconnAddr_delete
{

// Login Constructor
public static SiebelDataBean siebelDataBean;
public Siebel_SconnAddr_delete() throws Exception
{
siebelDataBean = new SiebelDataBean();
siebelDataBean.login("siebel.TCPIP.None.None://lngnpvappc006v:2320/siebelom/eMediaObjMgr_enu/siebel", "CRMLOAD", "CRMLOAD", "enu");
}


public static void Siebel(oracle.sql.ARRAY p_in) throws java.sql.SQLException,IOException,java.lang.Exception
{
try {
System.out.println("before string");
String[] values = (String[])p_in.getArray();
System.out.println("after string");

if( siebelDataBean == null)
System.out.println("siebelDataBean null");

siebelDataBean.traceOn("d:\\sea752\\siebsrvr\\log\\abc.txt","SQL","");
System.out.println("Siebel string");
SiebelService myService = siebelDataBean.getService("MH DeleteAddressRecord");


SiebelPropertySet myInput = siebelDataBean.newPropertySet();
SiebelPropertySet myOutput = siebelDataBean.newPropertySet();


for( int i = 0; i < p_in.length(); i++ ) {

System.out.println( "p_in["+i+"] = " + values[i] );
myInput.setProperty("Id", values[i]);
myService.invokeMethod("DeleteRecord",myInput,myOutput);
String Out_prop = myOutput.getProperty("ErrorMsg");
System.out.println( "Output ["+ values[i] +"] = " + myOutput.getProperty("ErrorMsg") );
}

myService.release();
siebelDataBean.traceOff();

}
catch (SiebelException e) {
System.out.println("Error#: " + e.getErrorCode());
System.out.println("Error Message: " + e.getErrorMessage());
}

}
}

Hi Tom I didn't knew where to ask it

I found this page
</code> http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html <code>

net seems more easy to learn but I need your advice please.
if you don't have one, could you ask from other person in Oracle, about Java vs NET in the database, please.

What had in mind Oracle to enable this features on the database, thank you

I think this question is valid only for those who works on windows.

The idea was if you can't do in sql neither on pl/sql then you can use java,

But if you use windows, now you can use net in the database, do you really need to use java, for example to call operating system executables, etc. etc.

Any comment?

Thanks Tom