Thursday, July 31, 2008

Windows dialog appears in

http://forums.asp.net/p/223035/384425.aspx

setting in internet explorer

Tools/InternetOptions/Security/LocalIntranet/CustomLevel/PrompForUserNameAndPassword

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()