Re: SELECT... INTO... problem
From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/05/25
Message-ID: <RxeX4.60$XQ1.15770_at_wdc-read-01.qwest.net>#1/1
Date: 2000/05/25
Message-ID: <RxeX4.60$XQ1.15770_at_wdc-read-01.qwest.net>#1/1
The user doesn't own any tables?
[Quoted] <pete_karanikas_at_hotmail.com> wrote in message
news:8gjkr2$fnu$1_at_nnrp1.deja.com...
> Why won't this work? (it's within a procedure)
>
> select count(*) into p_count
> from user_tables;
>
> The p_count has been declared as an INTEGER and is always returned as a
> value of 0.
>
> Any ideas?
>
> Pete
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu May 25 2000 - 00:00:00 CEST