Stored Procedure Data Source
\The Sandbox \PB History & Future \New in PB 4 \DW and Reporting \Specifying Data Sources \Stored Procedure Data Source
Select Painter
Multi-Table
Quick Select
Stored Procedure
Data Source
Oracle and
Stored Procedures

The Data Window preference variable stored_procedure_build determines how the result set of a DataWindow using a stored procedure gets generated.

When the variable is set to 1 (the default), you are not prompted for the result set description when you select stored procedure as the data source for a DataWindow or report. When stored_procedure_build is 1, the procedure is executed and the result set description is built automatically. To edit the description, click the SQL Select icon or select Edit Data Source from the Design menu.

Tip       To see the syntax for the stored procedure in the Select Stored Procedure dialog, click the More button.

To define arguments for the stored procedure, click the Arguments button. The Specify Retrieval Arguments dialog displays. To select another procedure, click the Procedures button. The Select Procedure dialog displays. 

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com