1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can any1 tel me the function of Slnn_Xsl.valueOf in the procedure below.,?!

Discussion in 'SQL PL/SQL' started by Vicky, Apr 29, 2014.

  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    PROCEDURE p_get_usr_rec_values (
    i_recnodeitem IN xmldom.domnode,
    o_usr_rec IN OUT typ_usr_rec,
    o_err_rec IN OUT typ_err_rec
    )
    IS
    BEGIN
    o_usr_rec.user_id :=
    Slnn_Xsl.valueOf (i_recnodeitem, '/PARAMETERS/HEADER/USER_ID');
    o_usr_rec.action :=
    Slnn_Xsl.valueOf (i_recnodeitem, '/PARAMETERS/HEADER/ACTION');
    o_usr_rec.domain_id :=
    Slnn_Xsl.valueOf (i_recnodeitem, '/PARAMETERS/HEADER/DOM_ID');
    DBMS_OUTPUT.PUT_LINE('dom'||o_usr_rec.domain_id);
    END p_get_usr_rec_values;
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi vicky,

    Slnn_Xsl is a custom package in your database.

    place this in toad and press f4 then it will show script of that.
     
    Vicky likes this.
  3. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Thanks Reddy., I got it.,