vb中我定义了一个函数ExecuteSQLORA 如下:
Public Function ExecuteSQLORA(strSQL As String) As Object
Dim OraSession As Object
'定义OraSession和OraDatabase为OLE对象
Dim OraDatabase As Object
'创建一个OraSession对象
Set objSession = CreateObject("OracleInProcServer.XOraSession")
'通过打开一个对Oracle的连接创建数据库对象
Set objDatabase = objSession.OpenDatabase("myoracle", "cgsys/cgsys", 0)
Set oraDynaSet = objDatabase.DBCreateDynaset(strSQL, 0)
Set ExecuteSQLORA = oraDynaSet
End Function
我拼装了一个字符串:
SQL="INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 1,4874277,'销售公司',77.98,22.1,55.88,'200807141617');
INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 3,1411010,'销售公司',75.3,19.8,55.5,'200807141621');
INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 4,4833525,'销售公司',77.12,22,55.12,'200807141622'); "
然后将该字符串传递给函数ExecuteSQLORA(SQL),结果出现错误: 实时错误'440'
SQL execution error,ORA-00911:invalid character我原以为是sql语句有问题,结果我到oracle数据库中执行该sql语句,没有问题,请问这是怎么回事?
Public Function ExecuteSQLORA(strSQL As String) As Object
Dim OraSession As Object
'定义OraSession和OraDatabase为OLE对象
Dim OraDatabase As Object
'创建一个OraSession对象
Set objSession = CreateObject("OracleInProcServer.XOraSession")
'通过打开一个对Oracle的连接创建数据库对象
Set objDatabase = objSession.OpenDatabase("myoracle", "cgsys/cgsys", 0)
Set oraDynaSet = objDatabase.DBCreateDynaset(strSQL, 0)
Set ExecuteSQLORA = oraDynaSet
End Function
我拼装了一个字符串:
SQL="INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 1,4874277,'销售公司',77.98,22.1,55.88,'200807141617');
INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 3,1411010,'销售公司',75.3,19.8,55.5,'200807141621');
INSERT INTO TRAIN_INFO_T(ID,TRAIN_NO,SUPPLY_UNIT,MAO_WEIGHT,PI_WEIGHT,JING_WEIGHT,MAO_TIME) VALUES ( 4,4833525,'销售公司',77.12,22,55.12,'200807141622'); "
然后将该字符串传递给函数ExecuteSQLORA(SQL),结果出现错误: 实时错误'440'
SQL execution error,ORA-00911:invalid character我原以为是sql语句有问题,结果我到oracle数据库中执行该sql语句,没有问题,请问这是怎么回事?
解决方案 »
- 问个关于mschart的问题[有图]
- VB中如何将SQL中指定字段值依次取出与指定数据对/ 在线等!
- 如何自动调整MSHFlexGrid行高
- 求助:我想通过VB程序来控制ACCESS数据库的密码,怎么实现?~~~~~
- 急急急!
- 再次散点分,相互鼓励一下.呵呵,程序钱已经到手.庆祝放分,给大家和自己多一点信心.
- 请高手指点,请问怎样在adodc1中加计算字段呀?
- VB6+access2003数据库连接问题
- 怎样把HTML代码在VB中输出成HTML文件?希望试例一下。
- 怎么将应用程序中text的值传送到另外一个应用程序TEXT中?
- 内心的焦虑... 自已的无奈...
- VB 数据库表导入到Excel的问题
若不出错,那就在一个事务里循环插入SQL.
我已经测试过!
如果可行,则可以用以下方式插入数据:insert into table (field1,field2...)
select 'value1','value2'... from dual union all
select 'value3','value4'... from dual union all
...
没用过Oracle Object Server,瞎猜的。
sql execution error .ORA-00911:invalid character