insert into table as select * from tablename或用pb 的数据管道
insert into tbname2@linkname select * from tbname1; 在vb中执行出现如下错误: ora-02041: 客户数据库未开始一个事务处理 请问为什么????????
begintrans?? committrans?? rollbacktrans??
什么意思能具体解释一下吗??我的程序如下: Dim sConn As String sConn = "Provider=OraOLEDB.Oracle.1;Password=gongsh;Persist Security Info=True;User ID=gongsh;Data Source=gongsh" Dim dbConn As New ADODB.Connection Dim dbSet As ADODB.Recordset
dbConn.Open sConn
dbConn.Execute "create database link dbBackupe1112 connect to system identified by manager using 'gongsh'" Set dbSet = dbConn.Execute("select * from aaa@dbBackupe1112")
Dim sTemp As String sTemp = CStr(dbSet.Fields(0))
dbConn.Close MsgBox sTemp在Set dbSet = dbConn.Execute("select * from aaa@dbBackupe1112")出现了上面的错误
在vb中执行出现如下错误:
ora-02041: 客户数据库未开始一个事务处理
请问为什么????????
committrans??
rollbacktrans??
Dim sConn As String
sConn = "Provider=OraOLEDB.Oracle.1;Password=gongsh;Persist Security Info=True;User ID=gongsh;Data Source=gongsh"
Dim dbConn As New ADODB.Connection
Dim dbSet As ADODB.Recordset
dbConn.Open sConn
dbConn.Execute "create database link dbBackupe1112 connect to system identified by manager using 'gongsh'"
Set dbSet = dbConn.Execute("select * from aaa@dbBackupe1112")
Dim sTemp As String
sTemp = CStr(dbSet.Fields(0))
dbConn.Close
MsgBox sTemp在Set dbSet = dbConn.Execute("select * from aaa@dbBackupe1112")出现了上面的错误