Re: SELECT... INTO... problem

Oh yeah... I forgot... the user has around 100 tables.

In article <RxeX4.60$XQ1.15770_at_wdc-read-01.qwest.net>,   "Mike Dwyer" <dwyermj_at_co.larImer.co.us> wrote:
> The user doesn't own any tables?
> <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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 25 2000 - 00:00:00 CEST