From: Date: December 28 2005 4:22pm
Subject: is there a type definition similar to the oracle rowtype
List-Archive: http://lists.mysql.com/mysql/193278
Message-Id: <003801c60bc2$85e6e360$dac8a8c0@aesys.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



Is there in mysql 5 a datatype similar to the oracle rowtype ?


To better explain I include the following example which should be working on
oracle and don't run on mysql

CREATE PROCEDURE pTest()
BEGIN

   declare c cursor for select * from table_test;
   declare crec c%rowtype;

   open c;
   fetch c into crec;
   close c;