如何从Oracle存储过程中获取两个返回值

概述我知道如何从Oracle中的Oracle SP获得一个返回值,如下所示 MyReturn := MY_ORACLE_SP (); 如果MY_ORACLE_SP2的返回值大于1.我能怎么做？ -- IN arguments : you get them. You can modify them locally but caller won't see it-- IN OUT arguments: 我知道如何从Oracle中的Oracle SP获得一个返回值,如下所示

MyReturn := MY_ORACLE_SP ();

如果MY_ORACLE_SP2的返回值大于1.我能怎么做？

-- IN arguments : you get them. You can modify them locally but caller won't see it-- IN OUT arguments: initialized by caller,already have a value,you can modify them and the caller will see it-- OUT arguments: they're reinitialized by the procedure,the caller will see the final value.CREATE PROCEDURE f (p IN NUMBER,x IN OUT NUMBER,y OUT NUMBER)ISBEGIN   x:=x * p;   y:=4 * p;END;/SET SERVEROUTPUT ONdeclare   foo number := 30;   bar number := 0;begin   f(5,foo,bar);   dbms_output.put_line(foo || ' ' || bar);end;/

产出：150 20

总结

以上是内存溢出为你收集整理的如何从Oracle存储过程中获取两个返回值全部内容，希望文章能够帮你解决如何从Oracle存储过程中获取两个返回值所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。