Re: Error ORA00904 - Invalid Column Name -HELP

OK,

So I can post my code but what ggod will that do since you are not familiar
with the columns. Like I said I was wondering if anyone had come into this
error before and what tools are available to trouble shoot pl/sql procs. I am
more interested in tools for debugging. I am guit sure you do not want to trudge
through 400 lines of code!!!!!

s

Sybrand Bakker wrote:
>
> yeah, what do you expect us to do when you don't post your code?
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> Sally Madeira <softsense_at_home.com> schreef in berichtnieuws
> 38FE0093.EF0ADF7_at_home.com...
> > I wrote a procedure to insert a resultset into a table and I am getting
> > an invalid column error. Now I have tried everything to determine what
> > column is the culprit but to no avail. Has anyone ever gotten this
> > error
> > and how did you resolve it. I checked all my column names and I did not
> > use any
> > reserved words. Is there any tools out there that can help me evaluate
> > this,
> > doing an explain plan does not do it for me.
> >
> > Deadline is coming fast and this procedure is pretty important
> >
> > thanks in advance
> > S
Received on Wed Apr 19 2000 - 00:00:00 CDT