Re: Package Compilation Problem

• Post for FREE via your newsreader at post.usenet.com ****

Hi Rod

> Hi, i'm using oracle 9.2.0.1.0, and am trying to create a package,
> here's a snippet...
>
> open mycur for
> select *
> from "OPS_HD_MAIL";
>
> when i try to compile the package i get the following errors...
>
> Line # = 14 Column # = 2 Error Text = PL/SQL: SQL Statement ignored
> Line # = 15 Column # = 7 Error Text = PL/SQL: ORA-06552: Compilation
> unit analysis terminated ORA-06553: PLS-320: the declaration of the type
> of this expression is incomplete or malformed

OPEN ... FOR takes as parameter a string. Therefore you should write:

open mycur for 'select * from OPS_HD_M';

Then it should work.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=