Forum Stats

  • 3,815,605 Users
  • 2,259,059 Discussions
  • 7,893,185 Comments

Discussions

Calling function within function as parameter

620922
620922 Member Posts: 9
edited Nov 4, 2011 4:28AM in Oracle Provider for OLE DB
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
This discussion has been closed.