toad报错内容:
ORA-06502: PL/SQL: 数字或值错误 : 字符到数值的转换错误
ORA-06512: 在 line 15
ORA-06512: 在 line 19sqlplus报错内容:
declare
*
ORA-01403:未找到任何数据
ORA-06512:在line 9
ORA-06512:在line 14
相关的表:
toad显示jobs表的column信息为:
JOB_ID NOT NULL CHAR(10)
JOB_TITLE CHAR(30)
MIN_SALARY NUMBER(6,1)
MAX_SALARY NUMBER(6,1)代码:
/* Formatted on 2008-11-20 18:36:29 (QP5 v5.115.810.9015) */
set serveroutput onDECLARE
G_TITLE jobs.job_title%TYPE;
G_ID jobs.job_id%TYPE; FUNCTION Q_JOB (cust_job_id JOBS.JOB_ID%TYPE)
RETURN NUMBER
IS
cust_job_title jobs.job_title%TYPE;
BEGIN
SELECT job_title
INTO cust_job_title
FROM jobs
WHERE job_id = cust_job_id; RETURN (cust_job_title);
END;
BEGIN
G_ID := 'SA_REP';
G_TITLE := Q_JOB (G_ID);
DBMS_OUTPUT.PUT_LINE (
'The job title of employee ' || G_ID || ' is' || G_TITLE
);
END;/
怎么回事呢?请高手指点!
ORA-06502: PL/SQL: 数字或值错误 : 字符到数值的转换错误
ORA-06512: 在 line 15
ORA-06512: 在 line 19sqlplus报错内容:
declare
*
ORA-01403:未找到任何数据
ORA-06512:在line 9
ORA-06512:在line 14
相关的表:
toad显示jobs表的column信息为:
JOB_ID NOT NULL CHAR(10)
JOB_TITLE CHAR(30)
MIN_SALARY NUMBER(6,1)
MAX_SALARY NUMBER(6,1)代码:
/* Formatted on 2008-11-20 18:36:29 (QP5 v5.115.810.9015) */
set serveroutput onDECLARE
G_TITLE jobs.job_title%TYPE;
G_ID jobs.job_id%TYPE; FUNCTION Q_JOB (cust_job_id JOBS.JOB_ID%TYPE)
RETURN NUMBER
IS
cust_job_title jobs.job_title%TYPE;
BEGIN
SELECT job_title
INTO cust_job_title
FROM jobs
WHERE job_id = cust_job_id; RETURN (cust_job_title);
END;
BEGIN
G_ID := 'SA_REP';
G_TITLE := Q_JOB (G_ID);
DBMS_OUTPUT.PUT_LINE (
'The job title of employee ' || G_ID || ' is' || G_TITLE
);
END;/
怎么回事呢?请高手指点!
SELECT job_title
INTO cust_job_title
FROM jobs
WHERE job_id = cust_job_id;
没查到结果阿。加个no_data_found异常。