Devart Forums

Hi
I am having issue with calling a procedure in package that has two input fields that are custom types (objects);

PROCEDURE Save_worksheet (Pworksheetdaytbl IN Ts_worksheet_day_tbl,
Pworksheetdaysectiontbl IN Ts_worksheet_day_section_tbl,
Puser IN Varchar2 DEFAULT USER
)

TS_WORKSHEET_DAY_TBL
TYPE "TS_WORKSHEET_DAY_TBL" AS TABLE OF WORKSHEET_DAY_Type;
TYPE "TS_WORKSHEET_DAY_TYPE" AS OBJECT
(
ID NUMBER,
WORKSHEET_ID NUMBER,
DAY_DATE DATE,
DAY_RANK NUMBER,
NUM_OF_CALLOUT NUMBER,
IF_STANDBY VARCHAR2(1),
IF_ALTERNATE_DAY VARCHAR2(1)
)


Day section is similiar

Do you have an example that i can follow to get this working with linq connect.

PS I have tried using oracleparameter but getting invalid type: TABLE when calling the "procedure"

LinqConnect does not support user-defined types and, in particular, Oracle object and table types.

If you are using dotConnect for Oracle Professional, you can use, e.g., the OracleObject and OracleTable classes to work with such objects. Also, you can create classes representing particular Oracle object types via the Object wizard.

Thanks for the quick repsonse


Is any of the future releases going to support it with linq connect?

At the moment, we do not plan to support this functionality in near future.

However, you can add this suggestion at our Uservoice :
http://devart.uservoice.com/forums/80267-linqconnect