Publish a Stored Procedure

1. Select the procedure under Stored procedures in the console's sidebar. DataIQ writes its CALL into the editor, with a placeholder for each input and a comment for each output.
2. Click Create API..., name the API and click Create. The procedure is not run. Its parameters are read from the database catalog, and each one is published with its type, so you do not declare them by hand.

What is supported

• Oracle: procedures and functions, including those in packages and overloaded ones, IN, OUT and IN OUT parameters, object types, collections and records, ref cursors, implicit results, CLOB, BLOB, BOOLEAN, XMLTYPE, intervals and zoned timestamps. A function's return value comes back as RETURN.
• SQL Server: procedures with input and OUTPUT parameters and any number of result sets, and scalar and table-valued functions. Table-valued parameters, sql_variant and CLR types are refused, and a procedure's RETURN status is not returned.

A parameter DataIQ cannot carry is refused when you publish, with the parameter named and the reason, rather than failing on the first call.