Skip to Content
0
Former Member
Feb 27, 2009 at 08:04 AM

UDF connection Oracle

101 Views

Hi experts,

In message mapping i've created a UDF, i need to know if the register exists in database before mapping.

Imports functions are: java.sql.;java.util.;java.sql.DriverManager;oracle.jdbc.driver.*;

But the follow compilation error occurs (6 errors):

D:/java:3: package oracle.jdbc.driver does not exist import com.sap.aii.mappingtool.tf3.;import com.sap.aii.mappingtool.tf3.rt.;import java.util.;import java.io.; import java.lang.reflect.;import java.sql.;import java.util.;import java.sql.DriverManager;import oracle.jdbc.driver.;

D:/java:219: package oracle.jdbc.driver does not exist DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

D:/java:221: cannot resolve symbol symbol : class OracleCallableStatement location: class com.sap.xi.tf._ORDERS05_TO_IDOC_OFERTAS_ CallableStatement pstmt = (OracleCallableStatement)con.prepareCall(storProc);

D:/java:221: cannot resolve symbol symbol : variable storProc location: class com.sap.xi.tf._ORDERS05_TO_IDOC_OFERTAS_ CallableStatement pstmt = (OracleCallableStatement)con.prepareCall(storProc);

D:/228: result is already defined in LB_ESTADO$(java.lang.String[],java.lang.String[],com.sap.aii.mappingtool.tf3.rt.ResultList,com.sap.aii.mappingtool.tf3.rt.Container) ResultSet result = stm.executeQuery(sql);

D:/java:239: cannot return a value from method whose result type is void return ret;

my level of java programming is very small..

very thanks by your help,