Using DataLayer.SP or Procedure.SP Elements

The Logi Studio elements designed to be used with stored procedures, DataLayer.SP and Procedure.SP can be used to retrieve data from an Oracle Package procedure. However, they behave slightly differently than they do in other circumstances.

The DataLayer.SP or Procedure.SP element's Command attribute uses a particular syntax, shown above, to identify the Oracle Package and Procedure. This is <packageName>.<procedureName>.

As shown above, set the SP Parameters element's Null Value attribute to NULL. You may use as many input parameters in your definition as you wish but do not use any output parameters. The data in the returned row set is referenced using @Data tokens as usual.