Posts

Showing posts from February, 2014

WSDL Design Style

WSDL stands for Web Service Description Language. WSDL defines the WSDL defines the Service, Port and Binding definition. It tells how the webservice is bound to the Message Protocol like SOAP. WSDL binding can be of two types, 1) RPC 2)Document RPC style the METHOD NAME  of the web service is visible, For Document style the  METHOD NAME  is not visible. Let's see the SOAP message and WSDL for different type of WSDL bindings. For the following JAX-WS service with RCP style @WebService @SOAPBinding(style = Style.RPC) public interface SimpleHellowService { @WebMethod String sayHi(String toName); }

SQL Store procedure Example

CREATE OR REPLACE PROCEDURE SIDD_USER_CREDITCARDS (   CUSTID IN NUMBER DEFAULT 77086,   CUSTCCNUM OUT VARCHAR2 ) AS SELECT_SQL VARCHAR2(4000); CUSTID_IN NUMBER; CURSOR s_cursor(s_customer_id NUMBER) IS SELECT CREDIT_CARD_ID AS ccnum FROM CREDIT_CARD_ENC WHERE customer_id in (s_customer_id); BEGIN   CUSTID_IN := CUSTID;   CUSTCCNUM := 10;        FOR cc_rec in s_cursor(CUSTID_IN)           LOOP             CUSTCCNUM :=cc_rec.ccnum;           END LOOP; END SIDD_USER_CREDITCARDS;