A script-enabled browser is required for this page to function properly.

Creating a Data Block from a FROM Clause

To create a data block from a procedure returning a table of records:

  1. In the Object Navigator, click the Data Blocks node.
  2. Click Create in the toolbar.
  3. In the New Data Block dialog, choose Build a New Data Block Manually and click OK.
  4. Double-click the Block object icon to display the Property Palette.
  5. Under the Database node:

  6. 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.

Query Data Source Type Property

Query Data Source Name Property

Using the FROM Clause as a Block Datasource

Connecting to a Database