Re: another PLS-00201
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,
- If there are synonyms, why don't you use it.
- You mention you read about the PLS-00201, did you check privileges)
rgds,
Guido
Received on Thu Jul 24 2003 - 08:26:14 CEST