Re: UTL_FILE and FormFeed character

From: JJ <jj123_at_yahoo.com>
Date: Tue, 19 Jun 2001 16:32:13 -0400
Message-ID: <9gobrm$78u7@kcweb01.netnews.att.com>

"Bhooshan S. Prabhu" <bhooshan.prabhu_at_citicorp.com> wrote in message news:2cf4efe2.0105312050.2600b052_at_posting.google.com...
> "PT" <g_abhi_at_yahoo.com> wrote in message
news:<9f34r6$knj7_at_kcweb01.netnews.att.com>...
> > I have tried using the package utl_file but i get the error
> >
> > ORA-06509: PL/SQL: ICD vector missing for this package
> >
> > Some web sites do say that this could be a problem due to "differences
in
> > version".
> >
> > Has anyone else faced this problem?
> >
> > Thanks,
> > PT
>
> With regards to ORA-6509 error, metalink has reports from people facing
same
> problem and Oracle support replies that the package which reports the 6509
> error, might not have been created using the SYS id. Please check if
that's
> the case with you and if yes, drop the utl_file package from the non-sys
> schema and create the same using the SYS schema.
>
> Regards
> Bhooshan

Thanks for the tip. Actually i was not creating the package using SYS(was not aware that it had to). Received on Tue Jun 19 2001 - 15:32:13 CDT