MySQL Forums
Forum List  »  Stored Procedures

Error 'Only input parameters are supported by MySql'
Posted by: Michael Caruso
Date: January 15, 2006 01:14PM

Running MySql 5.0.18 on Windows Server 2003, IIS 6 and .Net Framework V2, using .Net Connector 1.0.7 for .Net V2, C# for application

Stored Procedure:
+++++++++++++++++++++++++++++++++++++
CREATE PROCEDURE `sp_CreateCustomer2`(
IN fname1 VARCHAR(50),
IN lname1 VARCHAR(50),
IN fname2 VARCHAR(50),
IN lname2 VARCHAR(50),
IN address VARCHAR(75),
IN telephone VARCHAR(10),
IN zipcode VARCHAR(10),
IN route INT,
IN route_type VARCHAR(20),
IN status VARCHAR(25),
IN start_date DATE,
IN promo VARCHAR(45),
IN stop_date DATE,
IN resume_date DATE,
IN route_cost DECIMAL,
IN payment DECIMAL,
IN pay_date DATE,
IN balance DECIMAL,
IN pay_type VARCHAR(20),
IN instructions VARCHAR(100),
OUT returnvalue INT
)
BEGIN
INSERT INTO customers (Fname1, Lname1, Fname2, Lname2, Address, Telephone, ZipCode, Route, RouteType, Status,
StartDate, Promotion, StopDate, ResumeDate, RouteCost, Payment, PayDate, Balance, PayType, Instructions)
VALUES (fname1, lname1, fname2, lname2, address, telephone, zipcode, route, route_type, status, start_date,
promo, stop_date, resume_date, route_cost, payment, pay_date, balance, pay_type, instructions);

SELECT LAST_INSERT_ID() INTO returnvalue;
END
++++++++++++++++++++++++++++++++++++++++++++++

TIA,

Michael

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 'Only input parameters are supported by MySql'
2823
January 15, 2006 01:14PM


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.