Question

新手写的一个oracle存储过程，求大神来改改错误

create or replace PROCEDURE USER_UPDATE (useridx in varchar2 ,username1 IN VARCHAR2 ,userpwd1 IN VARCHAR2 ,SAMEX OUT NUMBER ) AS BEGIN IF SELECT USERNAME FROM TB_USER username=username1 THEN SAMEX :=1 ; ELSE UPDATE TB_USER SET username=username1,userpwd=userpwd1 WHERE userid=useridx; SAMEX :=0 ; END IF; commit; END USER_UPDATE;
create or replace
PROCEDURE USER_UPDATE
(useridx in varchar2
,username1 IN VARCHAR2
,userpwd1 IN VARCHAR2
,SAMEX OUT NUMBER
)
AS
BEGIN
IF SELECT USERNAME FROM TB_USER username=username1 THEN
SAMEX :=1 ;
ELSE
UPDATE TB_USER SET username=username1,userpwd=userpwd1
WHERE userid=useridx;
SAMEX :=0 ;
END IF;
commit;
END USER_UPDATE;

Answer 1

这样试试

create or replace PROCEDURE USER_UPDATE 
(useridx in varchar2 ,
username1 IN VARCHAR2,
userpwd1 IN VARCHAR2,
SAMEX OUT NUMBER)
AS
v_count int;
BEGIN   
SELECT count(*) into v_count FROM TB_USER username=username1;
IF v_count>0 THEN    
SAMEX :=1 ;
ELSE    
UPDATE TB_USER SET username=username1,userpwd=userpwd1    
WHERE userid=useridx;     
SAMEX :=0 ;
END IF;  
commit;
END USER_UPDATE;

追问

Error(10,1): PL/SQL: SQL Statement ignored
Error(10,51): PL/SQL: ORA-00933: SQL 命令未正确结束
还是不行啊

追答

你吧，我也没数据，在你那调试，查收下，屏幕右上角