Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

Calling function within function as parameter

620922Nov 4 2011 — edited Nov 4 2011
We're planning to switch from MS-OLEDB to Oracle OLEDB and are expecting several troubles.
One of these is that MS supports calling functions with another function within whilst Oralce does not?

Example (works fine with MS):
{? = call *<FUNCTION_1>* ( ?, ?, *<FUNCTION_2>* ( ?, ?, ? ) + 1, ?, 1 )}

This raises ORA-01036: Variablenname/-nummer ungültig with Oracle's OLEDB.

Any ideas?
Thanks in advance!

Edited by: user617919 on 04.11.2011 01:28
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2011
Added on Nov 4 2011
#oracle-provider-for-ole-db, #windows-and-net
0 comments
133 views