You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Problem with Stored Procedure Invoke

edited Nov 5, 2018 12:19PM in Integration 2 comments

Summary

Unable to invoke Stored Procedure when has Associative Array as input

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!