hey thanks for the reply, Im new to this, so please bare with me, what parameters am I missing? and isn't me setting the item = to portal.wwsbr_api.modify_item the function?
SET SERVEROUTPUT ON
--Get the item information
where masterID = 41089;
where name = 'FOOT';
l_item_id := portal.wwsbr_api.modify_item
p_perspectives => l_perspectives.id,
p_perspectives_caid => l_perspectives.caid
dbms_output.put_line('The Item was updated');
This is the error: "PLS-00306: wrong number or types of arguments in call to 'MODIFY_ITEM'"
We know what you do to call the MODIFY_ITEM function - it is the "l_item_id := ..." line.
But we still don't know how the MODIFY_ITEM function looks like. I'd like to see
CREATE OR REPLACE FUNCTION modify_item (par_1 number, par_2 number, par_3 char) return number
It is practically impossible to guess what you did wrong if you don't provide complete information about the case.
In other words: are p_perspectives and p_perspectives_caid the ONLY parameters? "_ID" suggests that those are NUMBERS. Are they? How does the "WWSBR_ALL_PERSPECTIVES" table look like? You used its values as IN parameters for the function. Did you match those data types or not?
[As the time goes by, more and more it looks like another my car is broken thread ...]