How do you call a function using embedded SQL

  • Document ID:3309492
  • Creation Date:15-Nov-2006
  • Modified Date:26-Apr-2012
    • Micro Focus Products:
      Identity Manager

Environment

Novell Identity Manager Identity Manager 3.0

Situation

How do you call a function using embedded SQL in Identity Manager (IDM)

Resolution

Instead of using the element, use the undocumented element:

test30

novell

instead of

declare i varchar2(1000); begin i:=ADMIN_USRMNG.create_db_user('test30','novell');end;

the output will look something like

1