Creating a Data Block from a FROM Clause
To create a data block from a procedure returning a table of records:
- Choose Tools | Data Block Wizard to invoke a
wizard that guides you through the process of building a data block.
Or,
- In the Object Navigator, click the Data Blocks
node.
- Click Create in the toolbar.
- In the New Data Block dialog, choose Build a New Data
Block Manually and click OK.
- Double-click the Block object icon to display the Property Palette.
- Under the Database node:
- Set the Query Data Source Type property to FROM clause.
- Type the a SELECT statement (sub-query) in the Query Data Source Name
text box.
- Under the General node, click the Name property,
then type a name or accept the default name. You can use any name that
follows ORACLE naming conventions and is unique among blocks in the form.
The block name is an internal descriptor that is not displayed at runtime.
Related topics
Query Data Source Type Property
Query Data Source Name Property
Using the FROM Clause as a Block Datasource
Connecting to a Database