User Guide > Procedures > Using Design Procedure By Example for Introspected Procedures
 
Using Design Procedure By Example for Introspected Procedures
You can use Studio or you can use the command line to complete the steps. These steps help make use of database procedures that have cursor outputs that might not be detectable by TDV until after the procedure has been executed by TDV.
These steps are helpful if you have Oracle procedures with cursor outputs that you want to use in further data customizations within TDV.
To use the design procedures by example functionality
1. Execute the procedure. For more information, see Executing a Procedure or Parameterized Query.
2. Provide valid input values to the procedure.
3. Review the cursor output and review the data type information.
TDV automatically does this for you, but reviewing at this stage can help you decide how you might want to make use of the data.
4. Save the cursor and data type information.
5. Use the saved information to design other TDV resources.
Alternatively, you can make use of the following API call from the command line or within a script:
designProcedureByExample <path> <inputs> <commitChanges>
• Provide the path to the procedure with the output cursors that you want TDV to execute.
• Provide valid input values for the procedure that you want TDV to execute.
• Set commitChanges to TRUE to save the output cursor metadata to the TDV repository for the procedure.