Home » RDBMS Server » Server Administration » ORA-03114: not connected to ORACLE.
ORA-03114: not connected to ORACLE. [message #53006] Fri, 23 August 2002 07:19 Go to next message
Venkat
Messages: 110
Registered: February 2001
Senior Member
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.

Report message to a moderator

Re: ORA-03114: not connected to ORACLE. [message #53008 is a reply to message #53006] Fri, 23 August 2002 08:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u using ODBC?
try to issue commit at every 2000 records or so.
this may cause the process to take a bit longer, but it would secured.

Report message to a moderator

Re: ORA-03114: not connected to ORACLE. [message #53010 is a reply to message #53006] Fri, 23 August 2002 08:40 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u using ODBC?
try to issue commit at every 2000 records or so.
this may cause the process to take a bit longer, but it would secured.

Report message to a moderator

Previous Topic: Creating INDEX on a particular Partition of a table
Next Topic: Dump Question! Oracle 11i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 16:31:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.