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
