I wonder if it would be possible (and useful) for DBD::Oracle to warn if
there are unbound params.
Tim.
On Mon, Jun 04, 2012 at 02:12:53PM -0400, Jeffrey Seger wrote:
> $dbh->do() executes your sql. You are binding the parameter after this.
> Use $dbh->prepare instead.
>
> On Mon, Jun 4, 2012
D'OH!
Thanks!
On Jun 4, 2012, at 11:12 AM, Jeffrey Seger wrote:
> $dbh->do() executes your sql. You are binding the parameter after this.
> Use $dbh->prepare instead.
>
> On Mon, Jun 4, 2012 at 2:01 PM, Bruce Johnson
> wrote:
>
>> I'm getting the following error:
>>
>> [Mon Jun 04 09:14:49 2
$dbh->do() executes your sql. You are binding the parameter after this.
Use $dbh->prepare instead.
On Mon, Jun 4, 2012 at 2:01 PM, Bruce Johnson
wrote:
> I'm getting the following error:
>
> [Mon Jun 04 09:14:49 2012] [error] [client 128.196.45.237]
> DBD::Oracle::db do failed: ORA-01008: not a
ers
John
>
> From: john...@pharmacy.arizona.edu
> Subject: Odd error using bind_param_inout
> Date: Mon, 4 Jun 2012 11:01:29 -0700
> To: dbi-users@perl.org
>
> I'm getting the following error:
>
> [Mon Jun 04 09:14:49 2012] [error] [client 128.196.45.237] DBD::Oracle::
I'm getting the following error:
[Mon Jun 04 09:14:49 2012] [error] [client 128.196.45.237] DBD::Oracle::db do
failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) [for
Statement "insert into resources (
short_name,long_name,building_id,room_desc,isaroom,numseats,numtables,hou