Re: [PHP-DB] oci8 and arrays as parameter
On Mon, Sep 10, 2001 at 03:50:08PM +0200, Ez-Berlin, E2boxb wrote: > hi list, read my paper from conf.php.net/oci - it should explain all that! tc > > I'm using PHP 4.0.6 and i want to give an array as parameter > from a php script to an oracle pl/sql - procedure... > > We had an older asp - site, witch used the same stored procedure, so > that it's clear, the procedure works... > In asp it calls "AddTable" to bind the parameter as array > > call without typ: > OCIbindbyname($stmt, ":P13", &$arr,-1); > -> Warning: > Array to string conversion in x on line y > > call with OCI_B_CURSOR: > OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); > -> Warning: > Supplied argument is not a valid OCI8-Statement resource in x on line y > > call with OCI_B_TABLE: > OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); > -> Warning: > Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y > > I got the same message with parameters: OCI_B_ARRAY, > OCI_B_VARRAY and any other typs > > Is this not possible with the current version? > > regards > Olaf Taesch > mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
I am using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]