orcl> create or replace function tried to return varchar2 is
  2  begin
  3  null;
  4  end;
  5  /

Warning: Function created with compilation errors.

orcl> show errors
Errors for FUNCTION TRIED:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/16     PLS-00103: Encountered the symbol "TO" when expecting one of the
         following:
         ( return compress compiled wrapped
         The symbol "TO" was ignored.

orcl>

04063, 00000, "%s has errors"
// *Cause:  Attempt to execute a stored procedure or use a view that has
//          errors.  For stored procedures, the problem could be syntax errors
//          or references to other, non-existent procedures.  For views,
//          the problem could be a reference in the view's defining query to
//          a non-existent table.
//          Can also be a table which has references to non-existent or
//          inaccessible types.
// *Action: Fix the errors and/or create referenced objects as necessary.

select sysdate from dual@CCBSTDBY;
select owner, username from dba_db_links where db_link='CCBSTDBY';

show user
select owner, object_name, object_type, status 
from dba_objects
where object_name in ('CCBSTDBY', 'CI_BILL')
/
select * from dba_synonyms where synonym_name='CI_BILL';

SQL> create or replace function coba return varchar2 is
2 result varchar2(20);
3 begin
4 select bill_id into result from ci_bill;
5
6 return(result);
7 end coba;
8 /

SQL> show user
User is "deepwell"
SQL> select owner, object_name, object_type, status
  2  from dba_objects
  3  where object_name in ('CCBSTDBY', 'CI_BILL')
  4  /
 
OWNER      OBJECT_NAME     OBJECT_TYPE        STATUS
---------- --------------- ------------------ -------
DEEPWELL   CI_BILL         SYNONYM            VALID
DEEPWELL   CCBSTDBY        DATABASE LINK      VALID

SQL> select * from dba_synonyms where synonym_name='CI_BILL';
 
OWNER    SYNONYM_NAME  TABLE_OWNER  TABLE_NAME   DB_LINK
-------- ------------- ------------ ------------ ----------------
DEEPWELL CI_BILL       CISADM       CI_BILL      CCBSTDBY

show user
select owner, object_name, object_type, status 
from dba_objects
where object_name in ('CI_BILL')
/
show parameter audit

SQL> show user
User is "deepwell"
SQL> select owner, object_name, object_type, status
  2  from dba_objects
  3  where object_name in ('CCBSTDBY', 'CI_BILL')
  4  /
 
OWNER     OBJECT_NAME   OBJECT_TYPE        STATUS
--------- ------------- ------------------ -------
DEEPWELL  CI_BILL       SYNONYM            VALID
DEEPWELL  CCBSTDBY      DATABASE LINK      VALID

SQL> select * from dba_synonyms where synonym_name='CI_BILL';
 
OWNER    SYNONYM_NAME   TABLE_OWNER    TABLE_NAME    DB_LINK
-------  -------------- -------------- ------------- -------------
DEEPWELL CI_BILL        CISADM         CI_BILL       CCBSTDBY

SQL> show user
User is "CISADM"
SQL> select owner, object_name, object_type, status
  2  from dba_objects
  3  where object_name in ('CI_BILL')
  4  /
 
OWNER      OBJECT_NAME    OBJECT_TYPE         STATUS
---------- -------------- ------------------- -------
CISUSER    CI_BILL        SYNONYM             VALID
CISREAD    CI_BILL        SYNONYM             VALID
RPTUSER    CI_BILL        SYNONYM             VALID
STGUSER    CI_BILL        SYNONYM             INVALID
STGREAD    CI_BILL        SYNONYM             INVALID
UATUSER    CI_BILL        SYNONYM             VALID
UATREAD    CI_BILL        SYNONYM             VALID
UATADM     CI_BILL        TABLE               VALID
CISADM     CI_BILL        TABLE               VALID
STGADM     CI_BILL        TABLE               VALID
 
10 rows selected
SQL> show parameter audit
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /oradb11/ccb00/product/10.2.0/Db_1/admin/ccbprod/adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string      
audit_trail                          string      NONE

SQL> select * from CI_BILL where rownum=1;
 
BILL_ID      BILL_CYC_CD WIN_START_DT ACCT_ID    BILL_STAT_FLG BILL_DT     DUE_DT      CRE_DTTM    COMPLETE_DTTM LATE_PAY_CHARGE_SW
------------ ----------- ------------ ---------- ------------- ----------- ----------- ----------- ------------- ------------------
000309858268                          0003000000 C             01/06/2011  25/07/2011  22/06/2011  22/06/2011    Y                  

SQL> show parameter global
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_context_pool_size             string      
global_names                         boolean     FALSE

declare
cursor a is
select bill_id from ci_bill;
begin
null;
end;
 
ORA-06550: line 4, column 21:
PL/SQL: ORA-04063: table "CISADM.CI_BILL" has errors
ORA-06550: line 4, column 1:
PL/SQL: SQL Statement ignored

privilege acquired via ROLE do not apply within named PL/SQL procedure.

declare
  cursor a is select bill_id from ci_bill;
begin
  null;
end;
/

SQL> declare
  2    cursor a is select bill_id from ci_bill;
  3  begin
  4    null;
  5  end;
  6  /
 
declare
  cursor a is select bill_id from ci_bill;
begin
  null;
end;
 
ORA-06550: line 3, column 35:
PL/SQL: ORA-04063: table "CISADM.CI_BILL" has errors
ORA-06550: line 3, column 15:
PL/SQL: SQL Statement ignored