How to use Array in Array of Json

--000000000000ff780005982aa0d0
Content-Type: text/plain; charset="UTF-8"

Dear Friends,
My function definition is as:

CREATE OR REPLACE FUNCTION schema1.samplefun1(
    vin_comp_cd smallint,
    vin_div_cd smallint,
    vin_loc_cd smallint[],
    vin_bt_cd integer[],
  )

Here instead of passing parameter I want to just send a single i/p in
Json[].

My problem is how to pass array in Json[] variable. And how to use in code.


Thanking You!
Monalee
Database Lead Engineer.

--000000000000ff780005982aa0d0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Dear Friends,<div>My function definition=
=C2=A0is as:</div><div><br></div><div><div>CREATE OR REPLACE FUNCTION schem=
a1.samplefun1(</div><div>=C2=A0 =C2=A0 vin_comp_cd smallint,</div><div>=C2=
=A0 =C2=A0 vin_div_cd smallint,</div><div>=C2=A0 =C2=A0 vin_loc_cd smallint=
[],</div><div>=C2=A0 =C2=A0 vin_bt_cd integer[],</div><div>=C2=A0 )</div><d=
iv><br></div><div>Here instead of passing parameter=C2=A0I want to just sen=
d a single i/p in Json[].</div></div><div><br></div><div>My problem is how =
to pass array in Json[] variable. And how to use in code.</div><div><br></d=
iv><div><br></div><div>Thanking You!</div><div>Monalee</div><div>Database L=
ead Engineer.</div></div></div>

--000000000000ff780005982aa0d0--