Devart Forums

Posted: **Wed 19 Dec 2007 19:56**

Hi,

I have a declared type with this body:

TYPE T_CLG IS RECORD
  (
      CLG_ID            TB_CLG.CLG_ID%TYPE, 
      CLG_NOME          TB_CLG.CLG_NOME%TYPE,
      CLG_DTCADASTRO    TB_CLG.CLG_DTCADASTRO%TYPE,
      CLG_OP_STATUS     TB_CLG.CLG_OP_STATUS%TYPE,
      PSS_ID            TB_CLG.PSS_ID%TYPE,
      CLG_TIPO          TB_CLG.CLG_TIPO%TYPE,
      CLG_SITE          TB_CLG.CLG_SITE%TYPE,
      CLG_EMAIL         TB_CLG.CLG_EMAIL%TYPE
  );

Then, I created a vararray of this type:

Code: Select all

TYPE V_CLG IS VARRAY(1) OF T_CLG;

How can I use CoreLab's library to work with this kind of structure in InputOutput parameter in a stored procedure/function?

Posted: **Mon 24 Dec 2007 12:13**

OCI does not support some features of PL/SQL. For exapmle, describing types that are defined in PACKAGE. It does not have representation of RECORD type on client side. OraDirect .NET works with RECORD type in stored procedure parameters by creating appropriate PL/SQL code. But it does not work with RECORD inside composite objects.

Devart Forums

[URGENT!!] Using Oracle Record Type

[URGENT!!] Using Oracle Record Type