Help with first stored procedure

From: Dieresis <dieresis_at_my-dejanews.com>
Date: Fri, 05 Mar 1999 20:18:57 GMT
Message-ID: <7bpe77$9m5$1@nnrp1.dejanews.com>

I am new to PL/SQL and trying to compile my first PL/SQL stored procedure. Following is the code. The compilation errors I get are

LINE/COL ERROR

-------- ---------------------------------------------------------
7/2      PL/SQL: SQL Statement ignored
7/21     PLS-00201: identifier 'RPSCHEMA.V_USERS' must be declared

Can anyone help? What am I doing wrong?

/* Procedure to retrieve userid given login and partner */

CREATE OR REPLACE PROCEDURE userid_get
(

	login_in IN VARCHAR2 ,
	partner_in IN VARCHAR2 ,
	userid_out OUT INTEGER

)
AS BEGIN

	SELECT	userid
	INTO	userid_out
	FROM	USERS
	WHERE	login = login_in
	AND	partner = partner_in;

END userid_get;
/

---Dieresis [dieresis_at_my-dejanews.com]

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 05 1999 - 14:18:57 CST