This discussion is archived
0 Replies Latest reply: Nov 4, 2011 1:28 AM by 620922 RSS

Calling function within function as parameter

620922 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points