Re: rowtype in mysql

[anupam tripathi]

brother there is no rowtype variable declaration in mysql to declare the variable u have to declare it as a simple data type as...
if this is in oracle

CREATE PROCEDURE ORA_SP_ROWTYPE (ROW1
OUT ora_rt%ROWTYPE) IS

then in mysql

CREATE PROCEDURE ORA_SP_ROWTYPE (OUT
SWV_ROW1_ID INT, OUT SWV_ROW1_NAME
VARCHAR(10))

u have to know all the fields...

Rgds
Anupam Tripathi