Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Stored Outlines For Queries In PL/SQL Stored Procs
Hi,
Oracle 8.1.7.3
SunOS 5.7
I would like to know how to create stored outlines for some queries I have in stored procedures. The queries may be explicit or implicit. For example:
DECLARE
TYPE VectorId_Type IS TABLE OF
cii_array_vector.vector_id%TYPE INDEX BY NATURAL;
var_VectorIds VectorId_Type;
varcur_datapoint cur_datapoint%ROWTYPE;
CURSOR cur_datapoint IS
SELECT b.*
FROM ciiw_array_vector a, datapoint b
WHERE a.array_id = ArrayId_in
AND a.vector_id = b.vector_id AND b.version = pdII.cWorkingVersion AND a.vector_id NOT IN (SELECT vector_id FROM matrix_vector);
BEGIN
FOR varcur_datapoint IN cur_datapoint LOOP
...
END LOOP;
SELECT ciiw_array_vector.vector_id
BULK COLLECT INTO var_VectorIds
FROM ciiw_array_vector, vector
WHERE ciiw_array_vector.array_id = ArrayId_in
AND ciiw_array_vector.vector_id = vector.vector_id
AND vector.version = pdII.cWorkingVersion;
END;
Thanks,
Salaam
Received on Thu Dec 05 2002 - 07:54:29 CST