iConsole Search Definition Reference Guide › Stored Procedures (SPs) › SP Implementation

SP Implementation

Although the detailed implementation of the SPs differs depending on the database engine, the SPs must always conform to a standard interface convention to be compatible with the iConsole.

Oracle

Searches defined for Oracle databases must be implemented as functions, taking positional parameters and returning a refcursor. The columns returned using the refcursor must match the search definition in terms of number, name and type.

SQL server

Searches defined for SQL Server databases must be implemented as procedures taking positional parameters. In addition:

• The final SELECT statement in the procedure must yield columns that match the search definition in terms of number, name and type.
• If a procedure contains multiple SELECT statements the directive NO COUNT ON must be included in the procedure.

Note: You can specify a search with no results column definitions. In this case the results are displayed based using the name and type of the returned column. The restriction that columns must match the search definition in terms of number, name and type does not apply in this case.