Using Oracle SQL Developer to Generate Code

Before you can use Oracle SQL Developer to generate code for activities, you must install the Oracle Data Miner PL/SQL Code Generator Extension for SQL Developer. You install the Code Generator Extension using the Help | Check for Updates selection in Oracle SQL Developer.

You can run programs that use generated code in Oracle SQL Developer. If you plan to use the debug feature of PL/SQL, you need the following grants:

Follow these steps to generate code from SQL Developer:

  1. Select a connection to a data mining server.
  2. Select File | New; the New Gallery opens.
  3. In the New Gallery, select All Items from the Filter By list.
  4. You can access the Code Generator extension in the Database Tier as Database Objects. Select Data Mining PL/SQL Package and click OK.
  5. The Data Mining PL/SQL Package Wizard is launched. Use the wizard to generate the package.

For an example of how to generate code and execute it, see Code Generation Example.