Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Stored Outlines For Queries In PL/SQL Stored Procs

Stored Outlines For Queries In PL/SQL Stored Procs

From: Salaam Yitbarek <yitbsal_at_yahoo.com>
Date: 5 Dec 2002 05:54:29 -0800
Message-ID: <77439c33.0212050554.1d3731ca@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US