Re: stored procedures runs once but fails later

We will be unable to help you unless you post (preferably both) further details on 'it didn't work' : any error messages, expected behavior etc. etc. etc.
The source of the procedure.
If possible at all you should also try to reproduce the behavior in sql*plus and sql*worksheet.

Regards,

Sybrand Bakker, Oracle DBA

"thalakola" <thalakola_at_email.msn.com> wrote in message news:#zHA3vd6$GA.278_at_cpmsnbbsa09...
> 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
>
>
>
>
Received on Sun Jul 09 2000 - 00:00:00 CDT