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?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
