Re: Run report errors on Report Writer

In <48hfvb$mgt_at_tst.hk.super.net>, Mike Chan <mike_at_dt.com.hk> writes:

When you use the select into statement your sql must only return one row. Is it possible that when the data was reloaded, duplicate rows were inserted? The best way to debug this is to issue the select statement in SQLPLUS without the INTO clause and see what data is returned, then fix the data or alter the query so that it returns only one row.

scott moyer
dmoyer_at_gpu.com (work)
dsmoyer_at_enter.net (home)

>Hello Oracle Experts,
>
> Our oracle have down recently due to the failure of the harddisk, and
>after replace the harddisk and restore data. We found that some of the
>report cannot be run. It always shows the error:
>
> ORA-2112 "PCC: SELECT..INTO returns too many rows"
>
> Can anyone tell me what wrong????
>
>
>Thanks in advance.
>
>
>Best Regards
>Mike Chan
>
Received on Fri Nov 17 1995 - 00:00:00 CET