PL/SQL (MOSC)

MOSC Banner

Issue with calling API - using array

edited Aug 17, 2012 6:20AM in PL/SQL (MOSC) 11 commentsAnswered ✓
Hi,
I am attempting to create user accounts for use with iSupplier Portal. I am calling POS_USER_ADMIN_PKG.Create_Supplier_User_account, but I am getting a wrong type or number of arguments in my call, see below. I am confident this has to do with the array variables, because if I comment them out, this runs without error.

Any help would be appreciated.

Thanks,
Paul


Error starting at line 311 in command:

DECLARE

l_user_name                     VARCHAR2(60)  := 'jhsu@yahoo.com';

l_user_email                      VARCHAR2(60)  := 'jhsu@yahoo.com';

l_person_party_id          NUMBER             := '788120';

TYPE number_table_type IS TABLE OF NUMBER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center