Oracle and VB6 Status / Validity Check ?

From: <stemp1ar_at_my-deja.com>
Date: Wed, 01 Sep 1999 22:46:39 GMT
Message-ID: <7qkacb$baf$1@nnrp1.deja.com>

I have been encountering this problem...

I have a stored procedure that calls a function. If I change the function it causes the procedure to become invalid. I have been told the next time Oracle runs the procedure it will recompile it and work fine and from the command line in SQL Plus it works fine, but when I run my VB front end application and call the invalid procedure it spits back an error.

Does VB check the STATUS or VALIDITY of a stored procedure before executing it and is there a way to change this setting or any way to get around it ?

Thanks in advance!

stemp1ar_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 01 1999 - 17:46:39 CDT