| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL bug ???
A copy of this was sent to "Jarek Palka" <triss_at_zeus.polsl.gliwice.pl>
(if that email address didn't require changing)
On Tue, 20 Oct 1998 14:44:27 +0200, you wrote:
>I wrote a PL/SQL function, similar to this one :
>
>CREATE OR REPLACE FUNCTION Unitest (pndmg number)
>RETURN NUMBER IS
> ile NUMBER ;
>BEGIN
> select sum(a)
> into ile
> from(
> select a from tst
> union all
> select 0 from dual
> );
>
> RETURN ile;
>END;
>
>
>Table TST is declared : TABLE TST (A NUMBER(5)); Table is empty.
>In my opinion function should return sum of values of column A from table
>TST, but if I issue statement :
>
You are correct, it is doing the wrong thing.
I've opened bug (not tar, bug) #749915 on this. You might call support to tell them you hit this bug to get updated when it gets fixed.
>
>Jarek Palka,
>P.I. Kamsoft
>Katowice, POLAND
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Oct 20 1998 - 10:17:48 CDT
 |
 |