以下存储过程编译时报错,请教大家是什么原因:
请教大家以下存储过程为何会出错:
create or replace package ytest as
type t_user_type is record(id t_user.id%TYPE,sex t_user.sex%TYPE);
function stu(id in t_user.id%TYPE)return t_user_type;
end ytest;create or replace package body ytest as
function stu(id in t_user.id%TYPE)return t_user_type
is r t_user_type;
begin
select id,sex into r
from t_user a where a.id=3; return r;
end stu;
end ytest;
错误信息为:pls:00103出现符号"create"
请教大家以下存储过程为何会出错:
create or replace package ytest as
type t_user_type is record(id t_user.id%TYPE,sex t_user.sex%TYPE);
function stu(id in t_user.id%TYPE)return t_user_type;
end ytest;create or replace package body ytest as
function stu(id in t_user.id%TYPE)return t_user_type
is r t_user_type;
begin
select id,sex into r
from t_user a where a.id=3; return r;
end stu;
end ytest;
错误信息为:pls:00103出现符号"create"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货