Hi, Hmm, strange - I've googled around and this is a pretty common error where the resolution is generally some subtle way the variables are defined and bound. I can't spot the problem, but play around with the query, perhaps some lowercase stuff, etc., and flags to the oci_bind_by_name() call.
H > -----Original Message----- > From: talk-boun...@lists.nyphp.org [mailto:talk- > boun...@lists.nyphp.org] On Behalf Of Eric Gewirtz > Sent: Wednesday, July 01, 2009 11:59 AM > To: 'NYPHP Talk' > Subject: Re: [nyphp-talk] oci8 bind error > > Hi Hans, > > Thks for the reply. > > I have double checked and the table I am testing with (KB_TEST) has one > field and it is VARCHAR(25). I believe the oci_parse() is working since > I'm > not "dieing" with an error message and the code gets to the > oci_bind_by_name(). > > > To your point that this "oci_bind_by_name ($stmt, ":TESTNAME", > "ERIC");" > should work - I do not get the oracle error when run this statment, I > get a > PHP fatal error: Only variables can be passed by reference. This makes > no > sense to me either. I get the oracle error when I run; > $val = 'ERIC'; > $bindVar = ':TESTNAME'; > oci_bind_by_name ($stmt, $bindVar, $val) > > So I just added some primitive type checking on the variables I'm > passing to > the bind and confirmed that $stmt is a resource, $val and $bindVar are > strings. > > I'm using is_string() and is_resource(). > > As to the ditching the "$insSQL = strtoupper($insSQL);"; I only added > it > because I was running out of ideas and I know ORACLE like to work with > upper > case (you can use mixed case but it is not fun). > > 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 Hans Zaunere > >Sent: Wednesday, July 01, 2009 11:04 AM > >To: 'NYPHP Talk' > >Subject: Re: [nyphp-talk] oci8 bind error > > > >Hello, > > > >> Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number > in > >> /appl/wideacc/CustMast/in/OCIpreptest.php on line 23 > > > > > >> Below is the test code I'm running; > >> > >> > >> //Connect to the Database > >> $dbUser = 'c1'; > >> $dbPSWD = p1'; > >> $db = 'db1'; > >> $con = oci_connect($dbUser, $dbPSWD, $db); > >> if (!$con) die ('Connect to DB failed'); > >> //$insSQL = 'INSERT INTO KB_TEST (TESTNAME) VALUES (:TESTNAME)'; > >> $insSQL = "INSERT INTO KB_TEST VALUES (:TESTNAME)"; > >> $insSQL = strtoupper($insSQL); // upper case since ORACLE prefers > upper > > > >I'd ditch this... > > > >> and we know we do not have a case issue > >> echo "SQL is $insSQL \n"; > >> $stmt = oci_parse($con, $insSql); > >> if (!$stmt) die ('Parse for insert failed'); > >> > >> //oci_bind_by_name ($stmt, ":TESTNAME", "ERIC"); > > > >This one seems as though it should work - are you sure the oci_parse() > is > >successful and that the first column in that table is really a > varchar? > > > >H > > > > > >_______________________________________________ > >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 _______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show_participation.php
