Hi:
We are trying to use CLOB in a 8.1.7 Oracle Server (linux). This is our first time with CLOB.
We have to sql:
1.sql=INSERT INTO esc_imagenes (id_imagen, nombre, alto, ancho, tamano,
tipo, descripcion, imagen) VALUES (87, 'prueba', NULL, NULL, 27, '', '',
'12345')
With no problem, but the second one...
- sql=EXECUTE ESC_P_CLOB.ESCRIBE_CLOB_IMAGEN(87, 2, '67890')
Return this error: ORACLE Error: ORA-00900: invalid SQL statement
This is the store procedure (perhaps it be important..)
PROCEDURE ESCRIBE_clob_imagen
( p_id_imagen esc_imagenes.id_imagen%type,
p_num_bloque NUMBER,
p_contenido_bloque VARCHAR2
)
IS
CURSOR c_IMAGEN IS
SELECT IMAGEN
FROM ESC_IMAGENES
WHERE ID_IMAGEN = P_ID_IMAGEN;
v_CLOB CLOB;
v_CANTIDAD INTEGER := 5;
BEGIN
OPEN c_IMAGEN;
FETCH c_IMAGEN INTO v_CLOB;
IF c_IMAGEN%FOUND THEN
DBMS_LOB.WRITE(v_CLOB, v_CANTIDAD,
(p_NUM_BLOQUE-1)*v_CANTIDAD+1,RPAD(p_CONTENIDO_BLOQUE, v_CANTIDAD,10));
END IF;
CLOSE c_IMAGEN;
END ESCRIBE_clob_imagen;
The problem is that I have read that oci8.so php module doesn't support CLOB types. somebody knows.. is it true???
Thankyou in advantage from Canary Island, Spain.
