[URGENT!!] Using Oracle Record Type

[URGENT!!] Using Oracle Record Type

Postby cidico » Wed 19 Dec 2007 19:56

Hi,

I have a declared type with this body:

Code: Select all
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?
cidico
 
Posts: 2
Joined: Wed 19 Dec 2007 14:07

Postby Paul » 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle