谁能帮我解决个问题？CSDN上就没高手了吗？

Question

我用PB调用ORACLE存储过程的时间，编译出现了一个警告，内容如下：
ora-04043 object "pblic".prc_log_yxsd does not exist
请问这是何故?好像是我调用存储过程的时候，没有指定存储过程所在的包？但是我建这个存储过程的时候也没有限定它属于那个包呀？？我的代码
declare prc_write_log procedure for prc_log_cg() //提示这行出的上述警告错误..
execute prc_write_log;

Answer 1

1.ora-04043 object "pblic".prc_log_yxsd does not exist
对象"pblic".prc_log_yxsd不存在。
2.建过程语法：
create [or replace] procedure procedure_name
[parameter_name [in | out | in out] date_type [,...]]
is | as
begin 
    procedure_body
end procedure_name;

Answer 2

3.调用过程
SQL窗口: 
3.1
   call   procedure_name(parameter); 
3.2
   begin   
       procedure_name(parameter);   
   end; COMMAND窗口: 
3.3 exec   procedure_name(parameter); 
3.4 execute   procedure_name(parameter); 
3.5 call   procedure_name(parameter); 
3.6
    begin
        procedure_name(parameter);
    end;

Answer 3

-- 注意oracle对象名的大小写！
-- 你可以在数据库中以sys登录去查一下这个名为"pblic".prc_log_yxsd是否存在
conn / as sysdbaselect object_name, object_type from dba_objects
wehre object_name=upper('prc_log_yxsd')
and owner='public' --估计是没有名为'public'的用户名(应该写成大写！)-- 查看数据库下的所有用户（主要是查看名为'public'的用户是否存在，注意大、小写)
sys@SZTYORA> select username from dba_users;USERNAME
------------------------------------------------------------
BOOKMGR
EYGLE
LYM3
OPS$SUN
SCOTT
LYM2
SZTYLYM
LYM
JULIA
TSMSYS
MDDATA
DIP
DBSNMP
SYSMAN
MDSYS
ORDSYS
EXFSYS
DMSYS
WMSYS
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
MGMT_VIEW
SYS
SYSTEM
OUTLN已选择29行。-- 从上面的查询结果可以看到，用户名默认都是大写，所以：当你用引号引用用户名时，
-- 引号里的用户名要用大写！示例如下：
sys@SZTYORA> select * from "SCOTT".emp;     EMPNO ENAME                JOB                       MGR HIREDATE                   SAL       COMM     DEPTNO
---------- -------------------- ------------------ ---------- ------------------- ---------- ---------- ----------
       111 SMITH                CLERK                    7902 1980-12-17 00:00:00        800            20
      7499 ALLEN                SALESMAN                 7698 1981-02-20 00:00:00       1600        300         30
      7521 WARD                 SALESMAN                 7698 1981-02-22 00:00:00       1250        500         30
      7566 JONES                MANAGER                  7839 1981-04-02 00:00:00       2975            20
      7654 MARTIN               SALESMAN                 7698 1981-09-28 00:00:00       1250       1400         30
      7698 BLAKE                MANAGER                  7839 1981-05-01 00:00:00       2850            30
      7782 CLARK                MANAGER                  7839 1981-06-09 00:00:00       2450            10
      7788 SCOTT                ANALYST                  7566 0087-07-13 00:00:00       3000            20
      7839 KING                 PRESIDENT                     1981-11-17 00:00:00       5000            10
      7844 TURNER               SALESMAN                 7698 1981-09-08 00:00:00       1500          0         30
      7876 ADAMS                CLERK                    7788 0087-07-13 00:00:00       1100            20
      7900 JAMES                CLERK                    7698 1981-12-03 00:00:00        950            30
      7902 FORD                 ANALYST                  7566 1981-12-03 00:00:00       3000            20
      7934 MILLER               CLERK                    7782 1982-01-23 00:00:00       5201            10
      8000 luoyoumou            MANAGER                  7782 2011-04-02 16:32:43       5000       1000         20已选择15行。sys@SZTYORA> select * from "SCOTT"."emp";
select * from "SCOTT"."emp"
                      *
第 1 行出现错误:
ORA-00942: 表或视图不存在
sys@SZTYORA> select * from "SCOTT"."EMP";     EMPNO ENAME                JOB                       MGR HIREDATE                   SAL       COMM     DEPTNO
---------- -------------------- ------------------ ---------- ------------------- ---------- ---------- ----------
       111 SMITH                CLERK                    7902 1980-12-17 00:00:00        800            20
      7499 ALLEN                SALESMAN                 7698 1981-02-20 00:00:00       1600        300         30
      7521 WARD                 SALESMAN                 7698 1981-02-22 00:00:00       1250        500         30
      7566 JONES                MANAGER                  7839 1981-04-02 00:00:00       2975            20
      7654 MARTIN               SALESMAN                 7698 1981-09-28 00:00:00       1250       1400         30
      7698 BLAKE                MANAGER                  7839 1981-05-01 00:00:00       2850            30
      7782 CLARK                MANAGER                  7839 1981-06-09 00:00:00       2450            10
      7788 SCOTT                ANALYST                  7566 0087-07-13 00:00:00       3000            20
      7839 KING                 PRESIDENT                     1981-11-17 00:00:00       5000            10
      7844 TURNER               SALESMAN                 7698 1981-09-08 00:00:00       1500          0         30
      7876 ADAMS                CLERK                    7788 0087-07-13 00:00:00       1100            20
      7900 JAMES                CLERK                    7698 1981-12-03 00:00:00        950            30
      7902 FORD                 ANALYST                  7566 1981-12-03 00:00:00       3000            20
      7934 MILLER               CLERK                    7782 1982-01-23 00:00:00       5201            10
      8000 luoyoumou            MANAGER                  7782 2011-04-02 16:32:43       5000       1000         20已选择15行。

Answer 4

sys@SZTYORA> select * from scott.emp;     EMPNO ENAME                JOB                       MGR HIREDATE                   SAL       COMM     DEPTNO
---------- -------------------- ------------------ ---------- ------------------- ---------- ---------- ----------
       111 SMITH                CLERK                    7902 1980-12-17 00:00:00        800            20
      7499 ALLEN                SALESMAN                 7698 1981-02-20 00:00:00       1600        300         30
      7521 WARD                 SALESMAN                 7698 1981-02-22 00:00:00       1250        500         30
      7566 JONES                MANAGER                  7839 1981-04-02 00:00:00       2975            20
      7654 MARTIN               SALESMAN                 7698 1981-09-28 00:00:00       1250       1400         30
      7698 BLAKE                MANAGER                  7839 1981-05-01 00:00:00       2850            30
      7782 CLARK                MANAGER                  7839 1981-06-09 00:00:00       2450            10
      7788 SCOTT                ANALYST                  7566 0087-07-13 00:00:00       3000            20
      7839 KING                 PRESIDENT                     1981-11-17 00:00:00       5000            10
      7844 TURNER               SALESMAN                 7698 1981-09-08 00:00:00       1500          0         30
      7876 ADAMS                CLERK                    7788 0087-07-13 00:00:00       1100            20
      7900 JAMES                CLERK                    7698 1981-12-03 00:00:00        950            30
      7902 FORD                 ANALYST                  7566 1981-12-03 00:00:00       3000            20
      7934 MILLER               CLERK                    7782 1982-01-23 00:00:00       5201            10
      8000 luoyoumou            MANAGER                  7782 2011-04-02 16:32:43       5000       1000         20已选择15行。