Hi All, I am working on wso2 data service server and trying to create data service using oracle function as the data source. in the function return type is a table type one. i tried many times but its not working for me. Is table type accessible through WSO2 DSS? also i have attached data service file and the plsql function and return type details and the error I got from SoapUI same in the mail. have you any idea about why this is not working. also there is no any issue in the database connection and its working for other services i created.
Regards, Akila Rathnayake This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.
service.dbs
Description: service.dbs
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";> <soapenv:Body> <soapenv:Fault xmlns:axis2ns92="http://ws.wso2.org/dataservice";> <faultcode>axis2ns92:DATABASE_ERROR</faultcode> <faultstring>DS Code: DATABASE_ERROR Nested Exception:- javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processStoredProcQuery': ORA-06550: line 1, column 12: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored DS Code: DATABASE_ERROR Source Data Service:- Name: IBaccountBalanceDetailType Location: /IBaccountBalanceDetailType.dbs Description: N/A Default Namespace: http://www.lolc.com/IBaccountBalanceDetailType Current Request Name: getAccountBalanceDetailType Current Params: {p_acc_type=S, p_acc_no=00110000001, req_type_id=, token_id=, rep_chnl=IB} Nested Exception:- java.sql.SQLException: ORA-06550: line 1, column 12: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored</faultstring> <detail> <axis2ns91:DataServiceFault xmlns:axis2ns91="http://ws.wso2.org/dataservice";> <axis2ns91:current_params>{p_acc_type=S, p_acc_no=00110000001, req_type_id=, token_id=, rep_chnl=IB}</axis2ns91:current_params> <axis2ns91:current_request_name>getAccountBalanceDetailType</axis2ns91:current_request_name> <axis2ns91:nested_exception>java.sql.SQLException: ORA-06550: line 1, column 12: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored</axis2ns91:nested_exception> <axis2ns91:source_data_service> <axis2ns91:location>/IBaccountBalanceDetailType.dbs</axis2ns91:location> <axis2ns91:default_namespace>http://www.lolc.com/IBaccountBalanceDetailType</axis2ns91:default_namespace> <axis2ns91:description>N/A</axis2ns91:description> <axis2ns91:data_service_name>IBaccountBalanceDetailType</axis2ns91:data_service_name> </axis2ns91:source_data_service> <axis2ns91:ds_code>DATABASE_ERROR</axis2ns91:ds_code> </axis2ns91:DataServiceFault> </detail> </soapenv:Fault> </soapenv:Body> </soapenv:Envelope>
//this is the details for plsql function,
function sent_ib_acc_balinq_detail_typ (p_acc_no in varchar2,
p_acc_type in varchar2,
req_type_id in varchar2,
token_id in varchar2,
rep_chnl in varchar2)
return dbt_ib_acc_balinq_detail_tab is
begin
return
pkg_sv_cyber_ib_savi_acc_dtl.sent_ib_acc_balinq_detail(p_acc_no, p_acc_type,
req_type_id, token_id, rep_chnl);
end;
end pkg_cyber_ib_proxy_savi_accdtl;
****************************************************
//This is the return type details
(account_number varchar2(30) null ,
account_type varchar2(3) null ,
amount number(17,2) null ,
available_balance number(17,2) null ,
currency_code varchar2(6) null ,
account_status varchar2(4) null ,
cif_no number null ,
start_date date null ,
end_date date null ,
due_day varchar2(3) null ,
int_rate varchar2(6) null ,
invester_ratio varchar2(6) null ,
company_ratio varchar2(6) null ,
profit_ratio varchar2(6) null ,
no_of_month varchar2(5) null ,
pay_mode varchar2(3) null ,
original_fd_no varchar2(30) null ,
renewal_indicater varchar2(100) null ,
monthly_rental number(17,2) null ,
rentals_in_arrears_amount number(17,2) null ,
current_due number(17,2) null ,
future_resiables number(17,2) null ,
vehicle_number varchar2(14) null ,
location_address varchar2(400) null ,
policy_period varchar2(4) null
)
/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
