create or replace procedure selectUser
(p_userID in varchar2,p_userPwd in varchar2, re_cnt out varchar2)
is v_cnt number;
begin
select count(*) into v_cnt from user_Pwd where User_Id=p_userID and Pass_Word=p_userPwd;
re_cnt:=to_char(v_cnt);
end;
execute SelectUser('asrs','asrs')
这样执行上面带参数的procedure对么?
PLS_00306:wrong number or types of argumernts in call to 'Selectuser'
(p_userID in varchar2,p_userPwd in varchar2, re_cnt out varchar2)
is v_cnt number;
begin
select count(*) into v_cnt from user_Pwd where User_Id=p_userID and Pass_Word=p_userPwd;
re_cnt:=to_char(v_cnt);
end;
execute SelectUser('asrs','asrs')
这样执行上面带参数的procedure对么?
PLS_00306:wrong number or types of argumernts in call to 'Selectuser'
解决方案 »
- ZHS16GBK 字符集的dump文件导入到AL32UTF8字符集会不会有丢失?
- oracle的2个监听问题:一个本地、一个服务器
- Oracle定义变量和字段时,number与number(n)有何区别?
- 游标参数的问题
- (高分)请问下面这样的语句,是在什么环境下去运行啊?
- 如何在存储过程中得到某个语句的执行时间
- Oracle菜鸟问题(关于登录Sql*Plus)
- 怎么用才能使ORACLE数据库中的游标循环多次?
- Oracle 7.3.4 安装问题!!!!!!!!!!!!!!!
- 求指导PLSQL截取字段第二个或者第二个和第三个字符怎么写?
- 在线等,求教sql语句
- 如何去掉该列数据后的空格 例如 'A50520 ' 改成 'A50520' 给我一条sql语句?谢谢了
execute SelectUser('asrs','asrs', :a);
2 begin
3 SELECT p1 INTO p2 FROM dual;
4 end test;
5 /Procedure createdSQL> var p2 varchar2;
SQL> exec test('test',:p2);PL/SQL procedure successfully completed
p2
---------
testSQL>