php-db | 2001011
Date: 01/10/01
- Next message: John: "[PHP-DB] Query Access DB by date"
- Previous message: Rubanowicz, Lisa: "RE: [PHP-DB] get last field from a table"
- Next in thread: Thies C. Arntzen: "Re: [PHP-DB] Ora_Bind problem"
- Reply: Thies C. Arntzen: "Re: [PHP-DB] Ora_Bind problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello!!
I've got a problem using Oracle 7 functions. When I'm trying to execute this commands:
Ora_Logon("jajejijoju <email protected>","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
Warning: Ora_Fetch failed (ORA-01002: búsqueda fuera de secuencia -- while processing OCI function OFETCH/OFEN) in /opt/www/htdocs/listatotaln.php3 on line 229
Are my commands ok? What's wrong in my program? Can anybody help me?
Thanks!!
David Díaz García
jdiaz <email protected>
- Next message: John: "[PHP-DB] Query Access DB by date"
- Previous message: Rubanowicz, Lisa: "RE: [PHP-DB] get last field from a table"
- Next in thread: Thies C. Arntzen: "Re: [PHP-DB] Ora_Bind problem"
- Reply: Thies C. Arntzen: "Re: [PHP-DB] Ora_Bind problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

