philzhou

导航

2013年8月22日 #

Operate blob data in Oracle via C#

摘要： oracle table: CREATE TABLE "SCOTT"."TEST_BLOB" ( "NAME" VARCHAR2(200), "PHOTO" BLOB ) Operating Code: private static void OprBlob() { var connStr = ConfigurationManager.ConnectionStrings["ora"].Con... 阅读全文

posted @ 2013-08-22 17:12 philzhou 阅读(255) 评论(0) 推荐(0) 编辑

ORA-01704: string literal too long

摘要： update mkt_page_links set longdescription = ' {some html text > 4000 char} ' where menuidno = 310;(longdescription type is clob)execute this cmd against oracle database via OracleClient, you will get the following error.ORA-01704: string literal too longCause: The string literal is longer 阅读全文

posted @ 2013-08-22 16:23 philzhou 阅读(3488) 评论(0) 推荐(0) 编辑