FunctionName (datatype String): Name of the
database function to call. This may be
a stored function, or a function
in a package. Parameter1 (datatype
Variant): Value that is passed to the function as the
first parameter. If omitted no function
parameters are used.
Parameter2 (datatype Variant): Value of the second function
parameter. To use more
than 2 parameters just keep adding parameter values.
SQLFunction Excel function executes a function in the database and displays the result
the cell. You can call a function with any
number of input parameters. It is also possible to call a
function in a package.
SQLFunctionVolatile does exactly the same but this function will always be
evaluated when Excel calculates.
Examples: A1: = SQLFunction(
"fn_invalid_objects" ) A2: = SQLFunction( "my_package.fn_inventory"
, D12 ) --Note that the function
fn_inventory is called in package my_package supplying the value in
D12 as the first function input parameter..
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.