This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Other Java Products and Servers and the fly likes problem while exposing stored procedures as web services using JDeveloper Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "problem while exposing stored procedures as web services using JDeveloper " Watch "problem while exposing stored procedures as web services using JDeveloper " New topic
Author

problem while exposing stored procedures as web services using JDeveloper

Shriyans Reddy
Greenhorn

Joined: Dec 21, 2011
Posts: 5
Hi,
I was able to generate the webservices for the stored proc's which are having primitive java types using Jdeveloper's create plsql wizard, as described in this site
http://oraclesoa.wordpress.com/2009/07/10/jdeveloper-11g-creating-plsql-webservice-and-deploying-to-weblogic-server/

But I want to expose PL/SQL stored procedures which are having complex input & output structures as Webservice via JDeveloper, complex meaning non-primitive java types.

When I try to generate the web services for the below stored procedures, I am not able to select the stored procedures from the wizard as they were greyed out and when I click on the why not button it showed me the below error message.

The following types used by the program unit do not have an XML Schema mapping and/or serializer specified:
IPGBALANCETRANSFER.TRANSFERITEMS_T



Below is my stored proc definition.

TYPE TransferItemRec_t IS RECORD
(
external_service ipgPaymentTransferDef.External_Service%TYPE,
discount_quantity INTEGER
);

TYPE TransferItems_t IS VARRAY(200) OF TransferItemRec_t;

PROCEDURE BalanceCarryIn(
pCustomerRef IN customer.customer_ref%TYPE,
pSubscriptionPS IN custhasproduct.subs_product_seq%TYPE,
pExternalOfferID IN ipgPaymentTransferDef.External_Offer_Id%TYPE,
pIRBOfferID IN ipgPaymentTransferDef.Irb_Offer_Id%TYPE,
pTransactionDtm IN DATE,
pTransactionID IN ipgtransactionaudit.transaction_id%TYPE,
pTransferItems IN TransferItems_t
);

PROCEDURE BalanceCarryOut(
pCustomerRef IN customer.customer_ref%TYPE,
pSubscriptionPS IN custhasproduct.subs_product_seq%TYPE,
pExternalOfferID IN ipgPaymentTransferDef.External_Offer_Id%TYPE,
pIRBOfferID IN ipgPaymentTransferDef.Irb_Offer_Id%TYPE,
pTransactionDtm IN DATE,
pTransactionID IN ipgtransactionaudit.transaction_id%TYPE,
pTransferItems OUT TransferItems_t
);


please help me.
Thanks in advance.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem while exposing stored procedures as web services using JDeveloper
 
It's not a secret anymore!