pass associative array to java in pl/sql

Question

I have a Java function with input parameters (HashMap >String, String> header, String url)

And I want to use Java function in PL/SQL.

I read that the type compatible with PL/SQL is an associative array.

But I spend a lot of hours and I can't find the solution.

I create a package to call java function because in function in PL/SQL can not use associative arrays.

So:

The package:

create or replace PACKAGE            SOLICITUDES_HTTP AS
 TYPE map_varchar2 IS TABLE OF VARCHAR2(255) INDEX BY VARCHAR2(255);
        Function Solicitud_Http_get (header IN map_varchar2,
    url IN VARCHAR2) return VARCHAR2;
END SOLICITUDES_HTTP;

COMPILE OK

The package body:

create or replace PACKAGE BODY SOLICITUDES_HTTP AS   
Function Solicitud_Http_get (header IN map_varchar2,
url IN VARCHAR2) 
RETURN VARCHAR2
IS LANGUAGE JAVA
NAME 'HTTP_Request.sendGet(java.util.HashMap,java.Lang.String) return java.lang.String';
END SOLICITUDES_HTTP;

COMPILE FAILS

Error(17,30): PLS-00999: restricción de implantación (puede ser temporal) INDEX TABLE BY CHAR/VARCHAR2 parameters are disallowed

Anyone can help me?

Thank you

Error is quiet clear. It says you cannot use associative array. Try with nested table. — XING
– XING, Commented Apr 4, 2018 at 10:21

MT0 · Accepted Answer · 2018-04-04 11:34:01Z

1

You cannot use a PL/SQL associative array like that - instead use a collection and modify your Java code to take two String arrays: one of keys; and one of values:

CREATE TYPE StringList IS TABLE OF VARCHAR2(255)
/

CREATE PACKAGE SOLICITUDES_HTTP AS
  FUNCTION Solicitud_Http_get(
    header_keys   IN StringList,
    header_values IN StringList,
    url           IN VARCHAR2
  ) return VARCHAR2;
END SOLICITUDES_HTTP;
/

CREATE PACKAGE BODY SOLICITUDES_HTTP AS
  FUNCTION Solicitud_Http_get(
    header_keys   IN StringList,
    header_values IN StringList,
    url           IN VARCHAR2
  ) return VARCHAR2
  IS LANGUAGE JAVA
    NAME 'HTTP_Request.sendGet(java.lang.String[],java.lang.String[],java.Lang.String) return java.lang.String';
END SOLICITUDES_HTTP;
/

answered Apr 4, 2018 at 11:34

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Iván Over a year ago

Thank you, Finally, i create two array for this, but type java.sql.array: <code>create or replace Function Solicitud_Http_get (headerKeys IN StringList, headerValues IN StringList, url IN VARCHAR2) return VARCHAR2 IS LANGUAGE JAVA NAME 'HTTP_Request.sendGET(java.sql.Array,java.sql.Array,java.lang.String) return java.lang.String';</code>

Collectives™ on Stack Overflow

pass associative array to java in pl/sql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related