Re: another PLS-00201

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 24 Jul 2003 08:26:14 +0200
Message-ID: <1059027833.502539_at_news.thyssen.com>


"windos" <windosab_at_yahoo.com> schrieb im Newsbeitrag news:3145998.1059012752_at_dbforums.com...
>
> Guys,
>
> I'm newbie here and tryin to create a simple procedure :
> ----
> CREATE OR REPLACE PROCEDURE update_status IS
> CURSOR cekstat is
> select b.CREATOR_PROC_INST_ID,
> b.MANAGED_FILE_ID,
> d.JOB_STATUS
> from other.rejprocesslog a,
> admin.managedfile b,
> admin.jobhasfile c,
> admin.job d
> where a.FILE_STATUS_ID=0
> and a.TO_DETIL_STAT=0
> and b.CREATOR_PROC_INST_ID=a.PROCESS_ID
> and b.MANAGED_FILE_ID=a.MANAGED_FILE_ID
> and c.MANAGED_FILE_ID=b.MANAGED_FILE_ID
> and d.JOB_ID=c.JOB_ID
> for update;
> BEGIN
> FOR rec in cekstat
> LOOP
> update rejprocesslog
> set rejprocesslog.FILE_STATUS_ID=cekstat.JOB_STATUS
> where rejprocesslog.MANAGED_FILE_ID=cekstat.MANAGED_FILE_ID;
> END LOOP;
> COMMIT;
> END update_status;
> /
> --
> But i got this error : PLS-00201: identifier 'ADMIN.MANAGEDFILE'
 must
> be declared.
> I've red couple of message like this posted in dbforums, but still i
 had
> the same error. the MANAGEDFILE,JOB and JOBHASFILE tables are
 already
> have synonims.
>
> Is there any ideas for this problems ??
>
> thank you.
>
> rgds,
> windos
>
> --
> -

Windos,

  1. If there are synonyms, why don't you use it.
  2. You mention you read about the PLS-00201, did you check privileges)

rgds,
Guido Received on Thu Jul 24 2003 - 08:26:14 CEST

Original text of this message