select in a object tables
| From: | Sergio | Date: | Tue, 17 Feb 2004 09:34:42 +0000 |
| Subject: | select in a object tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32973@lists.php.net to get a copy of this message | ||
¡Hi all!
I have a problem and I don't find the solution, my problem is when I try to do a select on a object table, it returns '*Warning*: Ora_Parse failed (ORA-00911: carácter no válido -- while processing OCI function OPARSE)'
I'm working with this code in pl/sql :
create Type TArtPrueba As object
(
codigo number,
nombre varchar2(20),
cantidad number
);
Create Type TAlmPrueba As VArray (10) of TArtPrueba;
create Type TPetPrueba As object
(
ident number,
articulosPeticion TAlmPrueba
);
create table Peticiones_Prueba of TPetPrueba
(ident Primary key,
articulosPeticion Not null);
To insert elements in the table:
insert into Peticiones_Prueba
values (333, TAlmPrueba(TArtPrueba(0,'Papel', 13),TArtPrueba(1, 'Boligrafos', 145)));
/
And the select that I use is :
SELECT
p.ident identificador,arti.* FROM Peticiones_Prueba p, table(p.articulosPeticion) arti; / This runs well in Oracle but when I try to call in php: $sql="Select arti.* from Peticiones_Prueba p, table(p.articulosPeticion) arti;"; ... $salida= ora_parse($cursor, $sql, 0); an error happends. Anybody now how to solve this problem?