Re: ORA-01008: not all variables bound

In at least the C++ file, you will see a line like:

static int sqlctx=1 const;

If you bind multiple files together, and have the same sqlctx in each file, you can receive this error (along with several others.) There is a patch for this bug, although I haven't seen it released in any full patches.

If that isn't the problem, I need to know more about your program. Is this using OCI, embedded SQL, or what? What type of call is giving you the problem? Does it happen in only one place or in every program that you write? (If in one place, what's unique about that place.)

Sorry if there are a lot of questions, but something like this isn't very easy to find. (Being on the end of finding the above bug!)

Terry Steyaert
steyaert_at_my-deja.com

In article <38FB163F.4C586ADB_at_mitre.org>,   Dawn Hersey <dawnh_at_mitre.org> wrote:
> In attempting to call an oracle stored procedure from either C++ or
 VB,
> we receive the error "ORA-01008: not all variables bound". The error
> code info gives no detail about this. Can anyone tell me what this
> means? The stored procedure is a simple one that implements a
 sequence
> number, returning an integer. It works fine when called from within
> Oracle. Thanks, Dawn
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 18 2000 - 00:00:00 CDT