Problem with Stored Procedure Invoke
Summary
Unable to invoke Stored Procedure when has Associative Array as inputContent
Hi,
I am trying to invoke a stored procedure from OIC through DB adapter, the invoke is trying to create a wrapper procedure and eventually fails to complete the design.
When Stored procedure has Associative Arrays, OIC tries to create a wrapper procedure, with out Type as input this works well.
Can some one please help me to fix this if this is supported in OIC.
Thanks,
Uday
Code Snippet
Here is my Procedure: create or replace PROCEDURE insert_cand_details( p_cand_id IN VARCHAR2, p_edu_level IN pkg_types.t_edu_level) AS counter NUMBER; BEGIN SELECT COUNT(*) INTO counter FROM cand_details WHERE cand_id = p_cand_id AND rownum=1; IF counter = 0 THEN -- The record did not exist, create it! dbms_output.put_line('record doesnt exist'); INSERT INTO cand_details(CAND_ID) VALUES(p_cand_id); --iterate the edu level array and insert FOR x IN p_edu_level.FIRST ..
Tagged:
0