tag:blogger.com,1999:blog-7395977411859619892.post5449292226600510103..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: Dummy output parametersRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7395977411859619892.post-28594724525775526522013-01-30T18:56:04.376+01:002013-01-30T18:56:04.376+01:00Hi Rob,
A couple of months ago I stood with the e...Hi Rob,<br /><br />A couple of months ago I stood with the exact same problem, which I solved in a slightly different fashion.<br />Taking your example:<br /><br />Using your example, I declare the record in a package, and a function to return all the values, this way I was able to use two of values executing only once:<br /><br />CREATE OR REPLACE PACKAGE do_something_tp<br />IS<br /> TYPE João Borges Barretohttps://www.blogger.com/profile/09625758342698621527noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-88646816662859463322013-01-29T21:02:07.706+01:002013-01-29T21:02:07.706+01:00An example from the Oracle PL/SQL Language Referen...An example from the Oracle PL/SQL Language Reference 11g Release 1 (11.1)<br />Example 8–22 Aliasing Passing Same Parameter Multiple Times<br />DECLARE<br />n NUMBER := 10;<br />PROCEDURE do_something (<br />n1 IN NUMBER,<br />n2 IN OUT NUMBER,<br />n3 IN OUT NOCOPY NUMBER) IS<br />BEGIN<br />n2 := 20;<br />DBMS_OUTPUT.put_line(n1); -- prints 10<br />n3 := 30;<br />DBMS_OUTPUT.put_line(n1); -- blogjehttps://www.blogger.com/profile/14785008192037832811noreply@blogger.com