Problem using Parallel Indexes

From: Don Bottstein <donb_at_mapquest.com>
Date: Thu, 09 Sep 1999 20:11:04 -0600
Message-ID: <37D868B8.A72DE68F@mapquest.com>

I'm seeing the following error when issuing a query that utilizes a parallel index:

ORA-12801: error signaled in parallel query server P000
ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-302: component 'ADDRESSUS' must be declared

ADDRESSUS is a function which does exist.

Also the query works fine if I remove the parallel attribute from the index -- i.e.:

alter index <index_name> noparallel;

Using Oracle 8.1.5.

Anyone seen this?

Thanks,
Don Bottstein Received on Thu Sep 09 1999 - 21:11:04 CDT