Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ora 1410, ora 6512
On Wed, 15 Aug 2001 13:21:51 -0400, Sunder
<sunder.nochilur_at_us.bosch.com> wrote:
>Hello All,
>
> I have a sql of the form
>
> select col1,col2,sum(col3),sum(col4)
> from
> (select col1,col2,sum(col3),0 from table1
> group by col1,col2
> union
> select distinct a.col1,a.col2,0,b.col4
> from
> table2 a,
> table3. b
> where a.id = b.id
> )
> group by col1,col2
> order by 1,2
>
>This sql works fine by itself. But, when I use the same sql in a curson,
>and then use the cursor in
>a procedure, i get following error.
>
>ora - 10410
>0ra - 06512
>
>If I use the procedure in a package and call the procedure from a
>package, the sql executes but gives
>erroneous results.
>
>Somebody, pleae help me.
>
>Sunder
Version? Those three digits and two dots please? Just 5 measly keystrokes?
Regards,
Sybrand Bakker, Oracle DBA Received on Wed Aug 15 2001 - 14:25:12 CDT