ÈçºÎÀûÓÃC#»ñÈ¡OracleµÄRowId£¿
ΪʲôÏÂÃæµÄ´úÂë¿ÉÒ԰ѼǼ²åÈëÄ¿±ê±íÄÚ£¬µ«Êä³ö²ÎÊýoracleRowIdȴΪnullÄØ£¿Õâ¸öoracleRowIdÓÖÓ¦¸ÃÔõÑù»ñÈ¡ÄØ£¿ C# code: public string GetOracleRowIdAfterInsertCommand(string OracleConnectionString) { string rowId = ""; OracleConnection conn = new OracleConnection(OracleConnectionString); try { OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = "begin "; cmd.CommandText += "INSERT INTO TABLEFORTEST (COLA,COLB) values ('A','B');"; cmd.CommandText += "end;"; conn.Open(); OracleString oracleRowId; cmd.ExecuteOracleNonQuery(out oracleRowId); rowId = oracleRowId.Value; } finally { conn.Close(); } return rowId; } ¸Ðл¸÷λ¸ßÊÖ£¡
rowId=cmd.ExecuteOracleNonQuery(out oracleRowId); rowIdÊÇָʲô£¿ÊÜÓ°ÏìµÄÐÐÊý£¿ ExecuteOracleNonQueryÊÇûÓзµ»ØÖµµÄÃüÁîÒýÓà rowId=cmd.ExecuteOracleNonQuery(out oracleRowId); rowIdÊÇָʲô£¿ÊÜÓ°ÏìµÄÐÐÊý£¿ ExecuteOracleNonQueryÊÇûÓзµ»ØÖµµÄÃüÁî rowIdÊÇOracleµÄÐбêʶ£¡ cmd.CommandText = &quo
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£» QQ£º413763818£» eamil:swebook@126.com ÍøÉÏÒ»´ó¶Ñ£¡ www.51aspx.com ȥϠ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......