想学一下怎么创建存储过程,下面写的总是编译有错,麻烦大家指点一下哪错了。CREATE OR REPLACE PROCEDURE GetUserInfo
@userId VARCHAR2(16),
@userName VARCHAR2(40) OUTPUT
AS
BEGIN
SELECT u.username FROM users u WHERE u.userid = @userId
SET @userName = u.username
END
GO
@userId VARCHAR2(16),
@userName VARCHAR2(40) OUTPUT
AS
BEGIN
SELECT u.username FROM users u WHERE u.userid = @userId
SET @userName = u.username
END
GO
v_username out varchar2) AS
BEGIN
SELECT u.username into v_username FROM users u WHERE u.userid = v_userid;
END
/
CREATE OR REPLACE PROCEDURE GetUserInfo(v_userid in varchar2,
v_username out varchar2) iS
BEGIN
SELECT u.username into v_username FROM users u WHERE u.userid = v_userid;
END;
name varchar2(40);BEGIN
SELECT u.username into name FROM users u WHERE u.userid = userId;
userName := name;
return userName;
END;
呵呵这些都是基本的东西,你要去多看看oracle基础你的那种写法有点像SQL的
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:;符号 ";" 被替换为 "end-of-file" 后继续。