Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Dialogs Parameters

Buy now

Download now

SQL*XL online help

SQL*XL: Object Parameter dialog: Value textbox

Direction dropdown (Parameter dialog)


The direction dropdown is used to specify whether a parameter is an In, Out or In/Out parameter. First select a parameter from the list, then specify the direction of the parameter using this dropdown.

With an In parameter you can give a variable to the database. You do this e.g. in select statements:

select * from emp where empno = :empno.

Out parameters are used to let the database give a variable back to SQL*XL. An example is the use of a function. In Oracle you could e.g. execute a function in a package using the following command:

begin :result := my_package.my_function(1,2,3); end;

In/Out parameters are used to give the database a variable and where the database returns the variable with a new value. An example is the use of a package with an in/out parameter. In Oracle you could e.g. execute a stored procedure using the following command:

begin my_package.my_procedure( :my_in_out ); end;

See also:

SQL*XL ribbon in Excel