Re: rowtype in mysql
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
Subject
Views
Written By
Posted
14455
February 21, 2006 01:50AM
8334
February 21, 2006 04:48AM
Re: rowtype in mysql
10457
August 20, 2008 12:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.