liguangyi:唉，可惜是window版本的。
(发表于2003-4-7 11:05:00)
jjqiao:这是原作者的补遗篇，要用这个类，一定读这一段。
不然不能增、删、改数据库。
Yes, but not a bug, I use db.Exec("commit")
--------------------------------------------------------------------------------
It would be a good feature to have a db.Commit() method that calls the OCI commit function, rather than passing the string to Exec() and creating a statement.
You are right that you don't want commit inside the Exec() method because sometimes you want to combine statements before commit. Also, if you use an anonymous block, you can use a commit inside there:
"begin
insert into tab1 values( 'a', 5 );
insert into tab5 values( 'a', 5, 78.90 );
commit;
end;"
Ultimately you have to explicitly perform the commit somewhere. I am sorry if you had to spend time investigating because your first intuition was probably that the COdb class was not working.
Thanks,
Ben
Submitted By: Ben Bryant (1999/09/23)
(发表于2003-5-10 10:06:00)
jjqiao:以下是乔建江对这个类的补充说明。
如要在不装oracle客户端的机上用这个类：
1.在安装了Oracle客户端程序后，在Oracle安装目录下有如下目录和文件是连接Oracle数据库服务器所必需的：（最好保持目录层次关系结构）
2.Oracle\BIN目录以及下面的27个DLL文件，并且保证应用程序可以找到该目录，即该目录为系统目录或者PATH目录。
3.Oracle\OCOMMON\NLS\ADMIN目录以及其下所有文件
4.Oracle\OCOMMON\NLS\MESG目录以及其下所有文件
5.Oracle\NETWORK\ADMIN\tnsnames.ora
6.Oracle\ORACORE\Mesg以及其下所有MSB文件
7.导入注册表到客户机：
REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"
"ORACLE_HOME"="D:\\oracle\\ora81"
"ORACLE_HOME_NAME"="OraHome81"
...
(发表于2003-5-10 10:09:00)
..........................................................................
--------------------next---------------------
