Can someone please tell me what I'm doing wrong?

Hi,

I have a single instance or Oracle (8) running, and I have created two schemas in it one called eSolutions the other called eArchive. The first holds the active data the other holds the archived. However, when I try to run the following procedure (contained within the eSolutions schema) :

CREATE PROCEDURE my_proc
(vID IN NUMBER, OK OUT NUMBER)
AS
BEGIN
SAVEPOINT del_usr ;
SET TRANSACTION READ WRITE ; INSERT INTO eArchive.Users
SELECT * FROM eSolutions.Users
WHERE eSolutions.User_ID = vID ;

DELETE FROM eSolutions.Users
WHERE eSolutions.User_ID = vID ;

IF SQLCODE = 0 THEN
 COMMIT ;
ELSE
 ROLLBACK TO del_usr ;
END IF ; OK := SQLCODE ; END ; I get an PLS-00201 error saying that User has to be declared. How do I get this to work.

Thanx in advance.

William Uurquhart. Received on Mon Dec 06 1999 - 11:54:10 CST