!!!Need help with stored pros

I am having a problem using stored procedures.

I created a simple stored procedure that selects a count(*) from a table using a where clause. I then tested the value of the count to see if there is data or not. I am using SQL Plus to test the procedure. If the table has data or not, the procedure executed successfully.

The only problem is why the value of the count is not equal to zero when there is no data.

e.g Select count(*) into X from table1 where field1 = input

         if X = 0 then
            raise_application_errors ( -0001,'message');
         end if; 

I would greatly appreciate assistance of any kind!!! e-mail: nikita_at_remus.rutgers.edu
Phone#: (908) 719-4416 (O)
Fax#: (908) 781-4959 (Att:SECC)x
uit Received on Wed Jun 07 1995 - 00:00:00 CEST