The reference to Users in the compilation error is with reference to the
first occurance of eArchive.Users
Wm. G. Urquhart <william_at_devnet-uk.net> wrote in message
news:vhV24.12318$0ju5.52167235_at_news5.usenetserver.com...
> 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 - 12:14:45 CST
