-
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
|
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|