-
Error when using PL/SQL table in a Where clause
Hi,
It gives me great happiness to write to you for the first time. I want
a solution from you for an error i am getting in one of my PL/SQL programs.
In my DECLARE block, i have a pl/sql table declared and a cursor:
DECLARE
type product_release_ids_tab_type is table of
aru_product_releases.product_release_id%type
index by binary_integer;
product_release_ids_tab product_release_ids_tab_type
cursor c_object_id is
select object_id
from aru_objects
where product_release_id in product_release_ids_tab;
-----------------------------------------------
Now i get an error 'Expression is of wrong type'
So then PL/SQL tables cannot be used in the where clause...?
Is there any work around for this. I am struck only with this problem. Can
you please help me out with this problem.
Thanks in advance
so long.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks