Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle Varchar2 LONG ³¤¶È£¿

ͻȻÔÚд³ÌÐòµÄʱºò·¢ÏÖÁ˸öСÎÊÌ⣬»·¾³ÎªOracle10g,¹¤¾ßPL\SQL DEVELOPER7.1.5 ,дһ¸ö´æ´¢¹ý³Ì
ÀýÈ磺
ÓÐÒ»¸ö±äÁ¿ V_I IN VARCHAR2(4000); 
ÏÂÃæÎÒÇó³ö´«ÈëµÄ×Ö·û´®µÄ³¤¶È
CREATE OR REPLACE PROCEDURE TEST_LENGTH(
V_I varchar2--´«Èë²ÎÊý
) IS
V_I_STR varchar2(4000);--´«Èë²ÎÊý
v_r number(8);--¼ÆÊý
BEGIN

V_I_STR := V_I;--´«Èë²ÎÊý

select length(V_I_STR) INTO v_r from DUAL;

DBMS_OUTPUT.put_line(v_r);

END;
Èç¹ûÎÒ´«ÈëµÄ×Ö·û´®´óÓÚ2001£¬¾Í»áÅ׳ö´íÎóora-01480 trailing null missing from STR bind value
Èç¹ûÎÒ´«ÈëµÄ×Ö·û´®Ð¡ÓÚ £¬µÈÓÚ2000£¬¾Í²»Å׳ö´íÎó¡£
²»ÖªµÀVarchar2£¨4000£©ÎªÉ¶ËõË®ÁË¡£¡£¡££¿£¿

Èç¹ûµ¥¶ÀÓÃLength£¨£©º¯Êý
SELECT LENGTH(str) from DUAL;
ÕâÀïÈç¹ûstrµÄ³¤¶ÈÎÒ´«Èë´óÓÚ4000µÄ¾Í»á±¨´íora-01704 string literal too lang

ÕâÀïÏëÎÊLength£¨£©º¯ÊýÖеÄ×Ö·û´®Ó㤶ÈÏÞÖÆ°¡£¿

---Èç¹ûÎÒ°Ñ´æ´¢¹ý³ÌÖеIJÎÊýÀàÐÍ»»³É LONG ÐÍ
CREATE OR REPLACE PROCEDURE TEST_LENGTH(
V_I LONG--´«Èë²ÎÊý
) IS
V_I_STR LONG;--´«Èë²ÎÊý
v_r number(8);--¼ÆÊý
BEGIN

V_I_STR := V_I;--´«Èë²ÎÊý

select length(V_I_STR) INTO v_r from DUAL;

DBMS_OUTPUT.put_line(v_r);

END;

ÕâÀïÎÒ´«ÈëµÄ×Ö·û´®³¤¶È ÊÇ4000£¬Õâʱ¿ÉÒÔͨ¹ýÁË¡£²»±¨´íÁË
µ«ÊÇÈç¹ûÎÒ´«ÈëµÄÊÇ4001£¬Õâʱ¾ÍÓÖ±¨´íÁË¡£¡£ORA-01460: unimplemented or unreasonable conversion requested



Çë¸÷λ´ó¸çÃǸøÐ¡µÜ½â´ð½â´ð£¬Ö¸µãÃÔ½òϱ»£¿ºÇºÇ ллŶ£


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ