Exception:Result consisted of more than one row
I am trying to insert variable number of rows in a table using a single insert statement. To do this i am using for loop. It was running fine. But i want to insert values for 4 tables and plus this multiple rows table. the remaining 4 tables insert only one row. i am using stored procedure for this. but the program is throwing an exception saying that "com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcepti on: Result consisted of more than one row ". Please give me a solution for this.
Thanks in advance