XMLTYPE to OBJECT

 Hi,

I created the following type:

CREATE OR REPLACE TYPE msg_sec_login_req AS OBJECT (

   user_id            VARCHAR2 (20)

 , PASSWORD           VARCHAR2 (20)

 , action             VARCHAR2 (20)

 , application        VARCHAR2 (20)

 , ip_address         VARCHAR2 (20)

 , mac_address        VARCHAR2 (20)

 , app_env_name       VARCHAR2 (20)

 , new_password       VARCHAR2 (20)

 , environment_type   VARCHAR2 (20)

 , token              VARCHAR2 (20)

 , session_id         VARCHAR2 (20)

);

Then to test I have this block:

DECLARE

   g_statuscode   VARCHAR2 (2000)   := '';

   v_in           msg_sec_login_req;

    auth_xml       VARCHAR2 (2000)

      :=    '<?xml version = "1.0"?>'

         || '<MSG_SEC_LOGIN_REQ>'

         || '<USER_ID>hello node</USER_ID>'

         || '<PASSWORD>pwd</PASSWORD>'

         || '<ACTION>LOGIN</ACTION>'

         || '<APPLICATION>WMS_CONNECTIONS</APPLICATION>'