我正在尝试创建一个包，它仅适用于过程。一旦我尝试添加一个函数，就会出现以下错误：
15:47:11 line 1: ORA-24344: success with compilation error
15:47:11 14/3 PLS-00103: Encountered the symbol "TITLE" when expecting one of the following:
15:47:11 . @ % ; is default authid as cluster order using external
15:47:11 character deterministic parallel_enable pipelined aggregate
15:47:11 result_cache accessible rewrite
15:47:11 The symbol ";" was substituted for "TITLE" to continue.
我的代码：
create or replace package job_pkg is
procedure add_job
(jobid jobs_test.job_id%type, jobtitle jobs_test.job_title%type);
---------------------------------------------------------------------
procedure upd_job
(alt jobs_test.job_id%type, neu jobs_test.job_id%type);
---------------------------------------------------------------------
procedure del_job
(jobid jobs_test.job_id%type);
---------------------------------------------------------------------
function get_job
(id jobs_test.job_id%type) return varchar2
title jobs_test.job_title%type;
end job_pkg;
先感谢您
你少了一个分号。
function get_job
(id jobs_test.job_id%type) return varchar2;
title jobs_test.job_title%type;
假设您正在创建一个包级变量“title”并在此处声明您的函数规范。
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句