Creating a user-defined function
You can create user-defined functions using a process design application such as the Microsoft Visio application.
- Create a .NET Class Library project.
- Specify the Target Framework as .NET Framework 4.0.
- Rename the default class and the class file for the function.
- Remove references that are not required.
- Provide a unique name such as <Study name>.<Function name> for the function.
- Include a reference to the Oracle.Designer.ExternalFunctions.dll assembly.
- Locate the assembly in <Central Designer Installation Directory>\Bin\ExternalFunctions.
- Copy the assembly to your project.
- Add a code statement to declare the namespace.
- If the function performs a task such as reading from or writing to a file, accessing the database or the registry, making web service calls, running an external application, sending an email, or using the event log directly, sign the function with a strong named signature that is valid and trusted.
For more information, see Signing user-defined function assemblies.
- Import the function into a library or study.
For more information, see Importing a user-defined function.