List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 15 2006 9:51am
Subject:Re: stored procedure TYPE
View as plain text  


> *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
Thread
stored procedure TYPELigaya Turmelle15 Jun
  • Re: stored procedure TYPEMartijn Tonies15 Jun