Home » Infrastructure » Windows » Error while executing a procedure in VB (VB, 6.0, Windows XP)
Error while executing a procedure in VB [message #333276] Fri, 11 July 2008 02:11 Go to next message
visairam
Messages: 11
Registered: March 2008
Location: Bangalore
Junior Member
Hi Everybody,

I have the following error
while executing the stored procedure
from my VB application.

It says as follows :
Error Number :3021

Error Description :
Either BOF or EOF is True,or the current record has been deleted. Requested operation requires a current record.

This code is working fine in my environment,
but throwing problem in test environment.

Please help me
Re: Error while executing a procedure in VB [message #333288 is a reply to message #333276] Fri, 11 July 2008 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ We don't have your code
2/ Is this an Oracle question?

Regards
Michel
Re: Error while executing a procedure in VB [message #333305 is a reply to message #333288] Fri, 11 July 2008 03:39 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

I can only guess, since your not giving us any information on what your stored procedure is doing.....

Quote:
This code is working fine in my environment,
but throwing problem in test environment.


Verfy that the data exists in both database.

Re: Error while executing a procedure in VB [message #333326 is a reply to message #333276] Fri, 11 July 2008 04:40 Go to previous message
visairam
Messages: 11
Registered: March 2008
Location: Bangalore
Junior Member
Hi

Thanks for your immediate reply.

This time iam giving the code.

Iam not sure where from this error is coming
( whether from VB or ORACLE ).

The code is as follows :


*********************************************************
'show an animation while user is waiting for a long process
Set moWait = New ATTWait.Processing
Me.Enabled = False
Me.MousePointer = vbHourglass

Call moWait.Display("FCE Audit", _
"The selected journals are being validated. " & vbCrLf & _
"Please wait .....")

sStoredProcedureName = "SP_VALIDATE_PACK_TEST.SP_VALIDATE_JOURNALS"

Set oCommand = New ADODB.Command
oCommand.CommandText = sStoredProcedureName

With oCommand.Parameters

.Append oCommand.CreateParameter("username", adChar, adParamInput, 8, moUser.UserName)

.Append oCommand.CreateParameter("rtn_msg", adChar, adParamOutput, 256, "")

End With

Call moData.ExecuteStoredProc(moUser.ConnectionString, oCommand)

*********************************************************
Previous Topic: DIM-00014
Next Topic: Need help with Installation of Oracle 11g release 1 on Vista Business
Goto Forum:
  


Current Time: Thu Mar 28 16:05:17 CDT 2024