By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,322 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,322 IT Pros & Developers. It's quick & easy.

another PLS-00201

P: n/a

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

--
-
Posted via http://dbforums.com
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"windos" <wi******@yahoo.com> schrieb im Newsbeitrag
news:31****************@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.