Hi,

I want to pass an array to a very simple Oracle SP, but when trying to
create the ARRAY object a "Fail to convert to internal representation"
SQL exception pops up. I think I've done everything allright, but
Oracle thinks I didn't... ,-))

The Oracle stuff look like that:

-----------------------------------------------------------------------
CREATE TYPE "DIVIDEND_DETAIL_OBJECT" AS OBJECT (
"HV_DAY" NUMBER(8, 0),
"EX_DAY" NUMBER(8, 0),
"PAY_DAY" NUMBER(8, 0),
"AMOUNT" FLOAT(64) );

CREATE TYPE "DIVIDEND_DETAIL_COLLECTION" AS
TABLE OF "DIVIDEND_DETAIL_OBJECT";

CREATE OR REPLACE PROCEDURE "SP_UPDATE_INSERT_DIVIDEND_LIST"
( in_div_id IN int,
in_div_version IN int,
in_div_udl_id IN int,
in_div_list IN dividend_detail_collection,
in_check_version IN int,
version_success OUT int,
new_version OUT int,
new_div_id OUT int )

IS
[...and so goes the SP...]
-----------------------------------------------------------------------


The relevant Java stuff looks like this:
-----------------------------------------------------------------------

public static class ddo {
int HV_DAY;
int EX_DAY;
int PAY_DAY;
float AMOUNT;
};

[...other stuff ommitted...]
OracleCallableStatement cstmt = (OracleCallableStatement)
oconn.prepareCall("{call
curvesbeta.SP_UPDATE_INSERT_DIVIDEND_LIST(?,?,?,?, ?,?,?,?)}");
ArrayDescriptor aDesc = new
ArrayDescriptor("DIVIDEND_DETAIL_COLLECTION", oconn);
int size = 2;
ddo[] elements = new ddo[size];
elements[0] = new ddo();
[...now setting the array content...]
ARRAY array = new ARRAY(aDesc, oconn, elements);

-----------------------------------------------------------------------

The last line in the above code throws the Java exception. Can anybody
shed some light on this? As from my understanding ddo is an exact
representation of the oracle type DIVIDEND_DETAIL_OBJECT and elements
is a java array of this "type", but Oracle claims there's an error -
but what exactly?


Any help is greatly appreciated ,-)

Soeren Gerlach

Soeren,

> Hi,
>
> I want to pass an array to a very simple Oracle SP, but when trying to
> create the ARRAY object a "Fail to convert to internal representation"
> SQL exception pops up. I think I've done everything allright, but
> Oracle thinks I didn't... ,-))
>
> The Oracle stuff look like that:
>
> -----------------------------------------------------------------------
> CREATE TYPE "DIVIDEND_DETAIL_OBJECT" AS OBJECT (
> "HV_DAY" NUMBER(8, 0),
> "EX_DAY" NUMBER(8, 0),
> "PAY_DAY" NUMBER(8, 0),
> "AMOUNT" FLOAT(64) );
>
> CREATE TYPE "DIVIDEND_DETAIL_COLLECTION" AS
> TABLE OF "DIVIDEND_DETAIL_OBJECT";
>
> CREATE OR REPLACE PROCEDURE "SP_UPDATE_INSERT_DIVIDEND_LIST"
> ( in_div_id IN int,
> in_div_version IN int,
> in_div_udl_id IN int,
> in_div_list IN dividend_detail_collection,
> in_check_version IN int,
> version_success OUT int,
> new_version OUT int,
> new_div_id OUT int )
>
> IS
> [...and so goes the SP...]
> -----------------------------------------------------------------------
>
>
> The relevant Java stuff looks like this:
> -----------------------------------------------------------------------
>
> public static class ddo {
> int HV_DAY;
> int EX_DAY;
> int PAY_DAY;
> float AMOUNT;
> };
>
> [...other stuff ommitted...]
> OracleCallableStatement cstmt = (OracleCallableStatement)
> oconn.prepareCall("{call
> curvesbeta.SP_UPDATE_INSERT_DIVIDEND_LIST(?,?,?,?, ?,?,?,?)}");
> ArrayDescriptor aDesc = new
> ArrayDescriptor("DIVIDEND_DETAIL_COLLECTION", oconn);
> int size = 2;
> ddo[] elements = new ddo[size];
> elements[0] = new ddo();
> [...now setting the array content...]
> ARRAY array = new ARRAY(aDesc, oconn, elements);
>
> -----------------------------------------------------------------------
>
> The last line in the above code throws the Java exception. Can anybody
> shed some light on this? As from my understanding ddo is an exact
> representation of the oracle type DIVIDEND_DETAIL_OBJECT and elements
> is a java array of this "type", but Oracle claims there's an error -
> but what exactly?
>

Without seeing the code for the object 'ddo' it's hard to tell exactly
what's going on here. Does your dividend detail object implement the
ORAData and ORADataFactory factory interfaces? If not then unhappiness
will ensue.

David Rolfe
Orinda Software
Dublin, Ireland