Call package inside procedure with Custom types as paramente

enigma51 · Post by **enigma51** » Tue 04 Oct 2011 02:58

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"

StanislavK · Post by **StanislavK** » Tue 04 Oct 2011 13:45

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.

enigma51 · Post by **enigma51** » Tue 04 Oct 2011 20:50

Thanks for the quick repsonse

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

StanislavK · Post by **StanislavK** » Wed 05 Oct 2011 15:46

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