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.






Comments

  • Justin BibJustin Bib USAMember Posts: 0

    _______ { http://forcoder.org } free ebooks and video tutorials about || C C++ Java MATLAB Swift Objective-C Go Python C# Delphi Assembly Scratch Visual Basic PHP PL/SQL R JavaScript Ruby Visual Basic .NET Perl Ada Rust Lua SAS Awk Scheme Bash Fortran Dart Julia Alice D Erlang Clojure Kotlin COBOL ABAP Lisp VBScript Scala Apex Transact-SQL LabVIEW Hack Logo F# ML FoxPro Crystal Prolog ||

Sign In or Register to comment.