Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Germany
    Posts
    9

    Unhappy Unanswered: converting of result set of a select query

    Hi folks

    I am a newbe in oracle9i(Re. 2). Is there any function for converting of the result set of a select query into XML, (dirct from PL*SQL engine, without java class) like the REC2XML from DB2- RDBMS.

    Thnx in advance

    Mehdi

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    22
    DECLARE
    --Declare the context handle
    queryCtx DBMS_XMLquery.ctxType;
    result CLOB;
    BEGIN
    -- Creates a query context and returns the context handle
    queryCtx := DBMS_XMLQuery.newContext('SELECT * FROM EMP');
    result := DBMS_XMLQuery.getXML(queryCtx);
    DBMS_XMLQuery.closeContext(queryCtx);
    END;
    /

Posting Permissions

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