Xref: alice comp.databases.oracle.server:47212
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!su-news-hub1.bbnplanet.com!su-news-feed4.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail
From: Andre Maasikas <amaasika@ee.oracle.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Error in Subquery in PL/SQL Procedure
Date: Mon, 26 Apr 1999 15:11:57 +0300
Organization: Oracle Baltics
Lines: 19
Message-ID: <3724580D.52DF7B06@ee.oracle.com>
References: <3714E815.A5EE66B3@mbnet.mb.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: inet16.us.oracle.com 925128740 149 192.188.171.57 (26 Apr 1999 12:12:20 GMT)
X-Complaints-To: usenet@inet16.us.oracle.com
NNTP-Posting-Date: 26 Apr 1999 12:12:20 GMT
X-Mailer: Mozilla 4.51 [en] (Win95; I)
X-Accept-Language: et,en



Brian Schalme wrote:
> 
>         Folks:
> 
>         Do subqueries really work in PL/SQL? For example when I try to compile
> this procedure:
> 
...
> 
>         I get the error message "PLS-00320: the declaration of the type of this
...
Looks similar to one issue i dealt with lately, might be oracle bug
388972.
Try to contacting your local support center and ask a patch for this
bug.

Andre