NYCPHP Meetup

[Eric Gewirtz]

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-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
>Behalf Of Daniel Convissor
>Sent: Thursday, July 02, 2009 7:34 PM
>To: NYPHP Talk
>Subject: Re: [nycphp-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