Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Oracle & VB..Help Help Help.......

venkatnavenkatna Member Posts: 1
[b][red]This message was edited by venkatna at 2002-8-23 6:45:36[/red][/b][hr]
Hi,
ORA-03114: not connected to ORACLE.

Iam trying to insert records one by one from VB to a table in Oracle database.
Here is the code sample
do while <>
lstrInsertSql = "Insert into employee Values(" & lstrInsertValues & ")"
Set lobjCommand = New ADODB.Command
lobjCommand.ActiveConnection = gobjADOProcess.mobjADO.FullConnect
Set lobjRS = gobjADOProcess.mobjADO.OpenRSDisconnected(lstrInsertSql)
lobjCommand.CommandText = lstrInsertSql
lobjCommand.Execute
Set lobjCommand = Nothing
.movenext
loop

Half way thru.... after inserting approx. 20,000 records, I get this error message
ORA-03114: not connected to ORACLE.

Please let me know how to handle large volume of data.
Please help.
Thanks in advance
ORA-03114: not connected to ORACLE.






Sign In or Register to comment.