stored procedures runs once but fails later

Hello,

I have a stored procedure in Oracle that excepts some parameters. This stored procedure ran well
for a few times in the morning when I called from Visual Basic and then didnot run later in the day.

I even tried running it from SQL plus and I get a compilation error.

I simply donot understand what is going on.

Inorder to make sure that this is repeatable, I renamed the stored procedure and when I called it from VB for the first time, it worked well and didnot work the second time.

I am not sure why that is the case.

I would appreciate you help.

Thank you.

• Reddy Thalakola