procedure proble

From: <wfrye_at_mnsinc.com>
Date: Tue, 12 May 1998 20:24:39 GMT
Message-ID: <6jab67$tmu$1@nnrp1.dejanews.com>

I recently tried this stored procedure create or replace procedure count_it as count_plus number; begin select count(*) into count_plus from session_roles where role = 'FAEMS_W_PMS21'; IF count_plus >= 0 THEN RAISE_APPLICATION_ERROR(-20999,'Faems user without authorization to perform this task over Usages'||count_plus); END IF;

end;
/
the resolts were as follows

ERROR at line 1:

ORA-20999: Faems user without authorization to perform this task over Usages0
ORA-06512: at "FAEMS_DBA.COUNT_IT", line 8
ORA-06512: at line 1

If i ran the select statement it created a count of 1. What is wrong?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 12 1998 - 15:24:39 CDT