c# ¶ÁÈ¡oracle¿â±íÖÐclob×Ö¶Î
ÏÖÔÚµÄÇé¿öÊÇ£ºÎÒÒѾ°ÑÕâ¸öÍøÒ³µÄÔ´´úÂë´æ´¢ÔÚ¿â±í£¨clob×ֶΣ©ÖУ¬½ÓÏÂÀ´µÄÎÊÌâÊǵÈÏ´ε÷ÓÃʱ»¹ÄܰÑÕâ¸öÒ³Ãæ»¹ÔÁË¡£Ò²¾ÍÊǰÑCLOBÖеÄÊý¾ÝÔÙ¶ÁÈ¡³öÀ´£¬»¹Ô³ÉΪ±£´æÇ°µÄÍøÒ³
ÒýÓà Response.Write(Server.HtmlDecode("clob×Ö¶Î")) Response.Write(Server.HtmlEncode("clob×Ö¶Î")) Èç¹û²»ÐеϰÊÔÊÔÕâ¸ö¡£¡£ ÏÈÊÔÊÔ Â¥ÏµļÌÐø Response.Write(clob×Ö¶Î) Èç¹ûÓаÑHTML±àÂëµÄ»°¾Í£º Response.Write(Server.HtmlDecode("clob×Ö¶Î")) Response.Write(Server.HtmlEncode("clob×Ö¶Î")) ½Ó·ÖÒýÓà Èç¹ûÓаÑHTML±àÂëµÄ»°¾Í£º Response.Write(Server.HtmlDecode("clob×Ö¶Î")) Response.Write(Server.HtmlEncode("clob×Ö¶Î")) ѧϰÁË Response.Write(Server.HtmlDecode("clob×Ö¶Î")) Response.Write(Server.HtmlEncode("clob×Ö¶Î")) Õý½â up
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True"); ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......