Hi Dan,
I found my bug (actually my partner found it)- embarrassed to admit it but
here it is - the sql to parse is being stored in a var called $insSQL and
the oci_parse is using $insSql (note the QL vs ql) I knew it was something
dumb :-(. Interesting that the oci_parse() does not throw an error on a null
or empty var.
$insSQL = "INSERT INTO KB_TEST VALUES (:TESTNAME)";
$stmt = oci_parse($con, $insSql);
if (!$stmt) die ('Parse for insert failed');
$val = 'ERIC';
$bindVar = ':TESTNAME';
ioci_bind_by_name ($stmt, $bindVar, $val))
Thks again. Btw, I tested without the length parm and the bind worked.
Eric
SolutionOne
Eric Gewirtz
162 Turk Hill Road
Brewster NY, 10509
Phone: 845-729-7800
FAX: 845-279-5502
>-----Original Message-----
>From: talk-boun...@lists.nyphp.org [mailto:talk-boun...@lists.nyphp.org] On
>Behalf Of Daniel Convissor
>Sent: Thursday, July 02, 2009 7:34 PM
>To: NYPHP Talk
>Subject: Re: [nyphp-talk] oci8 bind error
>
>Hi Eric:
>
>On Thu, Jul 02, 2009 at 01:32:22PM -0400, Eric Gewirtz wrote:
>>
>> Thanks I truly appreciate your help - With some minor tweaks this code
>does
>> work so at least I know it is not our version of php on the SUN box.
>
>Good. Sorry it had some bugs. I hate sending out code without testing
>it myself.
>
>
>> I'm not
>> yet sure why the bind works here and not in my sample because I also
>passed
>> in variables to the bind and I'm in the process of trying to get mine to
>> work.
>
>Your code doesn't set the length and the type parameters in the bind
>call. Not sure if that's why it's failing, but it's possible.
>
>Enjoy the long weekend,
>
>--Dan
>
>--
> T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
> data intensive web and database programming
> http://www.AnalysisAndSolutions.com/
> 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
>_______________________________________________
>New York PHP User Group Community Talk Mailing List
>http://lists.nyphp.org/mailman/listinfo/talk
>
>http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
