Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can someone please tell me what I'm doing wrong?

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

From: Wm. G. Urquhart <william_at_devnet-uk.net>
Date: Mon, 6 Dec 1999 19:14:45 +0100
Message-ID: <PAV24.12321$0ju5.27853455@news5.usenetserver.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US