Results 1 to 2 of 2

Thread: Oracle To SQL

  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Angry Unanswered: Oracle To SQL

    I have an oracle procedure that needs to be converted to ms-sql.

    lXMLContext := DBMS_XMLQuery.newContext("select * from table");
    -- Setup parameters on how XML is to be constructed.
    DBMS_XMLQuery.useNullAttributeIndicator(lXMLContex t,FALSE);
    DBMS_XMLQuery.setRaiseNoRowsException(lXMLContext, FALSE);
    DBMS_XMLQuery.setRaiseException(lXMLContext,TRUE);
    DBMS_XMLQuery.propagateOriginalException(lXMLConte xt,TRUE);
    DBMS_XMLQuery.setRowTag(lXMLContext,lWS.wsXMLRecor d.wsViewName);
    DBMS_XMLQuery.setDateFormat(lXMLContext,lDateMask) ;

    Any one can help in constructing a similar pattern in ms-SQL or atleast tell me what is all these doing?

    I am coding this using extended stored procedure in c#.

    Thanks,
    Venkat.

  2. #2
    Join Date
    Dec 2004
    Posts
    47
    Go thru the below link and see if u get any help...

    http://www.experts-exchange.com/Data..._21185214.html

    Here what i could understand is..

    It created the object 'lXMLContext' & set the parameters for this object for creating XML... U just need to concentrate on the last 2 only here I think so 'setRowTag' & 'setDateFormat'... the first 2 is set as 'FALSE' so u need not have to bother... the 3rd & 4th I feel its some sort of exception feature in ORACLE... to intimate the user that an error has occured while creating the XML...

    Sorry if u could already understand this much and was asking asking for anything more.....

    lXMLContext := DBMS_XMLQuery.newContext("select * from table");

    -- Setup parameters on how XML is to be constructed.

    DBMS_XMLQuery.useNullAttributeIndicator(lXMLContex t,FALSE);
    DBMS_XMLQuery.setRaiseNoRowsException(lXMLContext, FALSE);
    DBMS_XMLQuery.setRaiseException(lXMLContext,TRUE);
    DBMS_XMLQuery.propagateOriginalException(lXMLConte xt,TRUE);
    DBMS_XMLQuery.setRowTag(lXMLContext,lWS.wsXMLRecor d.wsViewName);
    DBMS_XMLQuery.setDateFormat(lXMLContext,lDateMask) ;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •