Re: DBI inconsistency (ORA-01008)

Is this really the code and what do you mean by "subsequent times produce error message". Do you really mean if you put your code in a file and run it from the command line it works once then never works again until you edit the code - I doubt it. Parameters once bound are sticky so there must be more to this than your code example shows.

Comment on Re: DBI inconsistency (ORA-01008)

Replies are listed 'Best First'.
Re^2: DBI inconsistency (ORA-01008) by thenaz (Beadle) on Aug 07, 2011 at 03:11 UTC
Actually, that is what I mean. And (other than replacing the oracle host/sid/user/pass with "bla") that is the _exact_ script I'm running. I'm not sure if the Oracle server is maintaining some kind of state associated with the host I'm connecting from or what. But when I put that into a pl file, and invoke it from the shell, it works the first time, but fails with subsequent invocations. (Which is really strange since each invocation is a separate process, separate connection to the DB, etc.)	[reply]

Replies are listed 'Best First'.

Re^2: DBI inconsistency (ORA-01008)
by thenaz (Beadle) on Aug 07, 2011 at 03:11 UTC

Actually, that is what I mean. And (other than replacing the oracle host/sid/user/pass with "bla") that is the _exact_ script I'm running.

I'm not sure if the Oracle server is maintaining some kind of state associated with the host I'm connecting from or what. But when I put that into a pl file, and invoke it from the shell, it works the first time, but fails with subsequent invocations. (Which is really strange since each invocation is a separate process, separate connection to the DB, etc.)

[reply]