SELECT... INTO... problem

From: <pete_karanikas_at_hotmail.com>
Date: 2000/05/25
Message-ID: <8gjkr2$fnu$1_at_nnrp1.deja.com>#1/1


[Quoted] [Quoted] 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 [Quoted] value of 0.

[Quoted] Any ideas?

Pete

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

Original text of this message