| Error while executing a procedure in VB [message #333276] |
Fri, 11 July 2008 02:11  |
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 #333326 is a reply to message #333276] |
Fri, 11 July 2008 04:40  |
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)
*********************************************************
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
