Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Functions are not using default and will not validate without direct input

810431Oct 26 2011 — edited Oct 27 2011
Hi. I am recreating all of our mappings (from 9.0 to 11g). And I am finding that any function that does not have a direct input for every input variable (rather than using the defaults as defined in the function) no longer will validate in OWB. It states that the input parameter is required but is not connected.

I have worked around this so far by adding Constants to pass the default values. I tried setting the default value in the property inspector window for each specific input parameter and this did not work, I still get the same error.

Is there a way to fix this? i am not happy with having to add all these constants, and I don't see why it is not using the defaults that are defined in the functions themselves. Any help is appreciated.

Thanks,
Kaisha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2011
Added on Oct 26 2011
3 comments
125 views