Schema Name. [message #39493] |
Fri, 19 July 2002 08:22 |
sverch
Messages: 582 Registered: December 2000
|
Senior Member |
|
|
I am perplexed. It looks like Oracle easily recognizes schema name in an annonimous block, but not in the named procedure.
For example:
SQL> show user
USER is "ITTR_TEST"
SQL> begin
2
3 UPDATE mo_case MC
4 SET i_status='TC'
5 WHERE c_id IN (SELECT c_id
6 FROM ittr_test3.m_case);
7
8 END;
9 /
PL/SQL procedure successfully completed.
SQL> select count(*) from mo_case where i_status='TC';
COUNT(*)
---------
2257
Everything is fine. But when I try to create stored procedure with the same code it fails:
SQL> CREATE OR REPLACE PROCEDURE TEST AS
2
3 begin
4
5
6 UPDATE mo_case MC
7 SET i_status='TC'
8 WHERE c_id IN (SELECT c_id
9 FROM ittr_test3.m_case);
10
11 END;
12 /
Warning: Procedure created with compilation errors.
SQL> show errors
Errors for PROCEDURE TEST:
LINE/COL ERROR
-------- -----------------------------------------------------------------
6/3 PL/SQL: SQL Statement ignored
9/11 PLS-00201: identifier 'ITTR_TEST3.M_CASE
must be declared
SQL>
If anybody knows why I beg you to please enlighten me!
|
|
|
|
|