Access Violation or Syntax Err from RDO to Oracle

From: Ricky Martin <>
Date: Wed, 26 May 1999 14:24:42 -0400
Message-ID: <>

Calling Oracle stored proc from VB/RDO/ODBC, sometimes we get Access Violation or Syntax Error.

We know some of the reasons for this error -
(1) Procedure not compiled - has become invalid due to some object
(2) Caller doesn't have execute permission

These reasons are ok and understandable and can be easily avoided. Another reason when this happens cannot be easily explained. I don't know what the reason is but after getting this error, if I FLUSH SHARED POOL then error goes away.

Can somebody throw some light on it ? Received on Wed May 26 1999 - 20:24:42 CEST

Original text of this message