Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Calling functions - NULL vs default

Calling functions - NULL vs default

From: PhilHibbs <snarks_at_gmail.com>
Date: 17 Jul 2006 02:32:20 -0700
Message-ID: <1153128740.157959.71690@b28g2000cwb.googlegroups.com>


In an Oracle function or procedure call, there can be parameters that have defaults, such as language code. If NULL is passed, this overrides the default. What I want to do is to create a table that mirrors the function's parameter list and call the function using the rows in that table, but I don't want to override defaults with NULLs. How can I do this? Is dynamically generating a function call the only way? Might this cause a significant performace hit, for instance if I were creating thousands of employees through the HRMS create_employee API?

Phil Hibbs. Received on Mon Jul 17 2006 - 04:32:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US