http://forums.asp.net/p/223035/384425.aspx
setting in internet explorer
Tools/InternetOptions/Security/LocalIntranet/CustomLevel/PrompForUserNameAndPassword
Thursday, July 31, 2008
Wednesday, February 06, 2008
Handling more than 4000 characters in XMLType columns in Oracle
TOAD will allow only 4000 characters if you insert XML document as string.
Inserting XML document to XMLType column
Resolution: Use PL/SQL block in TOAD
declare x CLOB;
BEGIN
x:='long long... xml statement';
insert into (xmlCol) values (xmltype(x));
END;
Select Statements for XML data of more than 4000 characters :
Resolution: Use
GETCLOBVAL() instead of GETSTRINGVAL()
Inserting XML document to XMLType column
Resolution: Use PL/SQL block in TOAD
declare x CLOB;
BEGIN
x:='long long... xml statement';
insert into
END;
Select Statements for XML data of more than 4000 characters :
Resolution: Use
GETCLOBVAL() instead of GETSTRINGVAL()
Labels:
4000 limit,
getclobval(),
getstringval(),
Oracle,
xmltype columns,
xmltype in oracle,
Xquery
Subscribe to:
Posts (Atom)