Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange problem - need to recompile a valid proc

Re: Strange problem - need to recompile a valid proc

From: Alan <alan_at_erols.com>
Date: Mon, 25 Oct 2004 12:45:14 -0400
Message-ID: <2u4ot0F253ie4U1@uni-berlin.de>

"tangman" <discusboy_at_gmail.com> wrote in message news:b382f4aa.0410250822.43eac527_at_posting.google.com...
> Hi. Hope one of you can help. I am currently running 9i and do a
> nightly export of one database schema to another exactly configured
> db. When I acess one of the proc. in the target db using ASP, I would
> get an error msg ora-06550 . I traced the proc and it show as valid.
> To fix the problem, I would need to recompile that proc and just that
> one proc. Anyone knows where is the problem? Thanks.

The 06550 by itself is useless to help solve the problem. What is the rest of the error message? What is the code? I am guessing that the asp code user that is running the procedure in question does not have direct rights to an underlying object, and when you recompile it, you are recompiling it and running it as the owner of the object, or at least as someone who has direct rights, but that's a wild guess, being as there is not enough information provided. Received on Mon Oct 25 2004 - 11:45:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US