Different ways of passing procedure's paramters

10-11  Source: Network gathering  Views:1 

Advertisement
Hi,
In the following example, I am calling the procedure p_test in different ways.
I understood from reading examples, that we can pass parameters using the syntaxe : " Name of the parameters => Value".
But I did not find anything official about it.
I'm just looking for Oracle Documentation where it is explained the syntaxe " Name of the parameters => Value".
CREATE OR REPLACE procedure test_call
is
procedure p_test(I_FIRST IN NUMBER DEFAULT 1, I_SECOND IN NUMBER DEFAULT 2 )
is
begin
dbms_output.put_line ('-----------------');
dbms_output.put_line ('FIRST:'||I_FIRST);
dbms_output.put_line ('SECOND:'||I_SECOND);
end;
begin
p_test(10,11);
p_test(10);
p_test();
p_test(I_FIRST => 100);
p_test(I_SECOND => 200);
p_test(I_SECOND => 2000, I_FIRST => 1000);
exception
when others then
ks_Error.log();
end;
/
note that the => is illegal in sql in 10g and before
select f(x=>1) from dual;
ERROR at line 1:
ORA-00907: missing right parenthesisbut it will probably be possible in 11g
Related articles
  • Different ways of passing procedure's paramters 10-11

    Hi, In the following example, I am calling the procedure p_test in different ways. I understood from reading examples, that we can pass parameters using the syntaxe : " Name of the parameters => Value". But I did not find anything official ab

  • What are different ways to pass variables in a c# program? 10-11

    What are different ways to pass variables in a c# program? I was wondering if : var numbers = textBox1.Text.Split(' .Select(int.Parse).ToArray(); var min = numbers.Min(); var max = numbers.Max(); textBox2.Text = string.Format("min: {0} max: {1}"

  • Ways of passing values/attributes between Portlets of pageflow 10-11

    Hi Jusing Bea WebLogic Workshop 8.1.5 where i have one Portal. The portalt contains: Page A with A.portlet with A.jpf and a.jsp Page B with B.portlet with B.jpf and b.jsp I want to click on a link on a.jsp which then goes to A.action in A.jpf, then r

  • Is there a different way to open a cursor for a ref cursor procedure? 11-30

    hello everybody i have two cursors, cur_a and cur_b, declared somewhere else in my application. These two cursors have the same fields, in the same order, and i have to treat both in the same way. So i wrote a routine that gets as input a ref cursor

  • Any way to pass Multiple Values for a single Label in the Parameter? 10-11

    I have a Report that Contains 2 Parameters, @Customer & @Area. When trying to set up the Available Values for @Area, I'm having issues using multiple values for one Label, i.e. = "4006" Or "4610" One of the Filters in the Report is

  • Is there a way of passing a mixed cluster of numbers and booleans to teststand 10-11

    Hi, I have a labview VI that contains an output cluster containing both numeric and boolean results and would like to pass this to Teststand. At the moment I have coverted all my boolean results to  '1/0'  so that I can create a numeric array and can

  • Is there a way to pass data between 2 seperate programs? 10-11

    I realize you can pass values to a program on boot but is there a way to pass information to a program after it's loaded? I want to make it so two seperate programs running on the same PC could exchange data back and forth. Where one program can call

  • Different ways to referencing Session State variables 10-11

    Hi, According to APEX documentation there's 4 different ways to reference session state variables: http://download-west.oracle.com/docs/cd/B32472_01/doc/appdev.300/b32471/concept.htm#BEICHBBG In an inline PL/SQL statement, what's the difference when

  • Different ways to return results using a stored proc to calling application 10-11

    Hi, Can someone please suggest me different ways of returning results( set of rows and columns) from a stored procedure to calling application. Currently I am using sys_refcursor to return results to front end. Stored proc is executed fast, but curso

  • Different ways to start a run? 10-11

    We have written a C-Sharp application that is a GUI wrapper around TestStand to hand-hold the operator through setup and execution of a test. I have noticed the following behavior differences with each of the different ways to start a sequence file r

  • XmlDataProvider .... is gone completely in my Xaml file. Why? How many different ways to deal with xml data source through WPF 10-11

    I followed a procedure described in a book. 1. insert "Inventory.xml" file to a project "WpfXmlDataBinding" . 2. add the XML data source through the data panel of "blend for 2013", named it "InventoryXmlDataStore" a

  • Proper Way To Pass Variables 11-30

    I know this is a basic question but it seems there are several different suggestions on how to do this. So using AS3 with Adobe Flash CS4, what is the correct way to pass a variable from a server side script "PHP" to my SWF? Thanksvar urlLdr:URL

  • Please Suggest best way to pass Strings in a pipeline 11-30

    I'm working in a project in which a line passes in a pipeline kind of situation. The String is passed between different modules and each module adds some more data to it (or may even remove some of it). Which is the best way to pass the String? I thi

  • Best way to pass data sets to another program 11-30

    Hey I want to connect another (maths) program with my java application. Therefore I need to paste data (some kind of tab separated table) to this program. I try now to save these data in a separate newly generated file and to pass a command with Java

  • The simplest way for plsql procedure to return multiple rows 10-11

    Hi, What is the simplest way for plsql procedure to return multiple rows (records). There are many combination of ways to do it but I am looking for a solution that is appropriate for plsql beginners. Many solutions use cursors, cursor variables, col

  • BI server generating  query in a different way between two instances 10-11

    Hi All, We have executed a report in dev,test instances,BI server generated query in a different way in two instances where as dev BI server is on AIX operating system(recently we migrated from windows),test instance is on still on Windows environmen

  • Different ways to setup applets... what's best? 10-11

    Alright. I need some help deciding how to setup an applet. I'm a high school student and I'm going to be in a competition on Saturday that will be using Java applets. I've been trying to get my hands on as much info about it as I can, but I've seen s

  • A different way to deal with "unknown" user after upgrade from Tiger. 10-11

    It's a known issue that doing upgrade and install or archive and install from Tiger to Leopard, produces a lot of folders with "unknown" group in their "get info" panel. This has to do with a different group structure in Tiger and Leop

  • Two separate versions of the same file corrupted in different ways... 10-11

    I was working on a Photoshop CS4 file last night that was created in CS4 and has only been opened on this machine in CS4. I saved the file and closed Photoshop. When I open the file today, all my layers are gone, flattened into one Background layer,

  • Multiple iPhoto libraries to manage photostreams in different ways 10-11

    My wife and I both have iPhone's. I have a 5s and she a 5. We share an iCloud account so that all photos she takes and ones I take go into one photostream and then automatically get loaded on my iMac hard drive. This way we are sure to not lose any p