Re: Ora_Bind problem
| From: | Thies C. Arntzen | Date: | Thu, 11 Jan 2001 09:56:56 +0000 |
| Subject: | Re: Ora_Bind problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5796@lists.php.net to get a copy of this message | ||
On Wed, Jan 10, 2001 at 01:37:17PM +0100, David Díaz wrote:
> Hello!!
>
> I've got a problem using Oracle 7 functions. When I'm trying to execute this
> commands:
>
> Ora_Logon("jajejijoju@pixies","doolittle");
> $cur = Ora_Open($conn);
> Ora_Parse($cur,"SELECT empresa,sedeprov,codigo,personal,produccion,mercados,
> gestion,sistemas,estudios FROM empresa ORDER BY
> :empresa");
> Ora_Bind($cur,"empresa",":empresa");
> Ora_Exec($cur,OCI_DEFAULT);
> while (Ora_Fetch($cur)) {
> $empresa = Ora_Getcolumn($cur,"EMPRESA");
> ....
>
> I get these warnings messages:
>
> Warning: Can't find variable for parameter in /opt/www/htdocs/listatotaln.php3 on line 228
if you use ora_bind in a function you have to declare the
bound php-variables global!
tc