Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# EAIDB_PROCS_SCHEMAS

Procedure Configuration

## Summary

This attribute is used to configure the additional schemas from which the stored procedures are fetched to list in the EAIDB step.

## Applies To

This attribute can be set for ALL processes.

## Permissible Values

To add additional schema names for procedure lookup.

    <schema>[,<schema>][,<schema@dblink>]...

## Default Value

This attribute is not defined on a newly installed iProcess Engine node. In this case, the default value is:

Machine ID | Process | Instance | Value
0 | ALL | 0 | `SWUSER`, `SWPRO`

The attribute only appears in the output of the `SHOW_ALL_ATTRIBUTES` command if you have explicitly assigned a value to it using the `SET_ATTRIBUTE` command. The default setting is not displayed.

## Notes

- The `EAIDB_PROCS_SCHEMAS` process attribute is only applicable to Oracle database version of the iProcess Engine.

- You need to add packages or stored procedures from additional schemas in `EAIDB_PROCS_SCHEMAS` as synonyms for `SWUSER` to prevent error during run-time.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2025. Cloud Software Group, Inc. All Rights Reserved.