从存储过程中检索出参数? [英] retrieve out parameter from stored procedure?

问题描述

我在oracle中创建了一个存储过程:

I have created one stored procedure in oracle:

PROCEDURE string_opp(input_string IN varchar2,output_string OUT varchar2)

现在的问题是如何执行此存储过程并检索输出参数.我在sql developer中遵循过:

Now the problem is how to execute this stored procedure and retrieve the output parameter.i've followed in sql developer:

SET SERVEROUTPUT ON
DECLARE
  outputString VARCHAR;
BEGIN
  EXEC string_opp('input String',:outputString);
END;

当我尝试此操作时，我什么也没得到，有人可以帮助我吗?

When i tried this i didn't get anything, could someone help me?

推荐答案

只有几个问题:

SET SERVEROUTPUT ON
DECLARE
   outputString VARCHAR(20);
BEGIN
  string_opp('input String', outputString);
  dbms_output.put_line(outputString);
END;

您可以将其用作同一变量:

You can use as the same variable:

SET SERVEROUTPUT ON
DECLARE
   outputString VARCHAR(20);
BEGIN
  outputString := 'input String';
  string_opp(outputString);
  dbms_output.put_line(outputString);
END;

只需将您的过程参数定义为IN OUT即可代替OUT.

Just define your procedure parameter as IN OUT in place of just OUT.

检查此资源:

http://psoug.org/snippet/FUNCTIONS-IN-OUT- parameter_873.htm

这篇关于从存储过程中检索出参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！