Hi,
I have got simple function as follows which returns clob:

function :TESTXMLQUERY

return clob is
queryCtx DBMS_XMLquery.ctxType;
result CLOB;
begin
-- set up the query context...!
queryCtx := DBMS_XMLQuery.newContext('select * from tab');
result := DBMS_XMLQuery.getXML(queryCtx);
DBMS_XMLQuery.closeContext(queryCtx); -- you must close the query handle..
return result;
end;

when i call this function from sql prompt it displays part of the out only like



CREATE$JAVA$LOB$T

Can anyone help me on this problem
thanks
kiran