From: Martijn Tonies
Date: June 15 2006 9:51am
Subject: Re: stored procedure TYPE
List-Archive: http://lists.mysql.com/mysql/198952
Message-Id: <009a01c69061$46e136b0$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: 7bit




> *Disclaimer - this will be kind of vague mainly because I only vaguely 
> recall the material.
> 
> I am trying to create a stored procedure.  Now I vaguely recall reading 
> something that says I have to match a column type if I am messing with 
> one.  Something like I want to match a table column type... even if I 
> don't know what it is.  I think it was something like TYPE 
> table.column... I'm not sure if it was only in a DECLARE or if I can set 
> one of the INOUT vars to the column type as well.

Oracle does that. MySQL, as far as I know, doesn't.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com