oracle掉用webservice,提示ORA-29532: Java 调用被未捕获的 Java 异常错误终止: java.lang.IllegalAccessException: java.lang.NoClassDefFoundError,请高手指教代码如下
create or replace
Function Test(
Xmlstring Varchar2
)
RETURN VARCHAR2
AS
l_service utl_dbws.SERVICE;
l_call utl_dbws.call;
l_result ANYDATA;
l_wsdl_url VARCHAR2(1024);
l_service_name VARCHAR2(200);
l_operation_name VARCHAR2(200);
L_Input_Params Utl_Dbws.Anydata_List;
code varchar(50);
Begin
L_Wsdl_Url := 'http://www.usoftchina.com/ws95/services/vendor?wsdl';
L_Service_Name := 'vendor';
L_Operation_Name := 'vendorinfo';
l_service := UTL_DBWS.create_service(wsdl_document_location=>URIFACTORY.getURI(l_wsdl_url),service_name=>l_service_name);
L_Call := Utl_Dbws.Create_Call(Service_Handle=>L_Service,Port_Name=>Null,Operation_Name=>L_Operation_Name);
L_Input_Params(0) := Anydata.Convertvarchar2(Xmlstring);
L_Result := Utl_Dbws.Invoke(Call_Handle=>L_Call,Input_Params=>L_Input_Params);
UTL_DBWS.release_call (call_handle=>l_call);
Utl_Dbws.Release_Service (Service_Handle=>L_Service);
RETURN ANYDATA.AccessVarchar2(l_result);
EXCEPTION
When Others Then
RETURN SUBSTR(sqlerrm,0,2000000000);
END test;webserviceoracle
create or replace
Function Test(
Xmlstring Varchar2
)
RETURN VARCHAR2
AS
l_service utl_dbws.SERVICE;
l_call utl_dbws.call;
l_result ANYDATA;
l_wsdl_url VARCHAR2(1024);
l_service_name VARCHAR2(200);
l_operation_name VARCHAR2(200);
L_Input_Params Utl_Dbws.Anydata_List;
code varchar(50);
Begin
L_Wsdl_Url := 'http://www.usoftchina.com/ws95/services/vendor?wsdl';
L_Service_Name := 'vendor';
L_Operation_Name := 'vendorinfo';
l_service := UTL_DBWS.create_service(wsdl_document_location=>URIFACTORY.getURI(l_wsdl_url),service_name=>l_service_name);
L_Call := Utl_Dbws.Create_Call(Service_Handle=>L_Service,Port_Name=>Null,Operation_Name=>L_Operation_Name);
L_Input_Params(0) := Anydata.Convertvarchar2(Xmlstring);
L_Result := Utl_Dbws.Invoke(Call_Handle=>L_Call,Input_Params=>L_Input_Params);
UTL_DBWS.release_call (call_handle=>l_call);
Utl_Dbws.Release_Service (Service_Handle=>L_Service);
RETURN ANYDATA.AccessVarchar2(l_result);
EXCEPTION
When Others Then
RETURN SUBSTR(sqlerrm,0,2000000000);
END test;webserviceoracle
解决方案 »
- 不显示删除回复显示所有回复显示星级回复显示得分回复 client/appServer/database架构,两客户端更新同一条数据同步问题。。。
- 同网段的数据库什么意思啊
- Oracel数据库采用双机热备后出现
- 统计数据的问题,不好弄
- oracle/dms/instrument/ExecutionContextForJDBC 驱动出了问题?
- 求助
- 金算盘---oracle数据库连接速度的问题?
- v$nls_parameters 和 v_$nls_parameters ???
- SQLSERVER不能,ORACLE能
- 创建抽象数据类型的问题
- Oracle10g 导入数据问题
- 请问oracle如何取消每10个数据就分一次组的情况?
这个异常好像说了问题。。 找不到类么。
http://docs.oracle.com/javase/1.4.2/docs/api/java/lang/IllegalAccessException.html