[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] delimiter and stored procedures
|
Hi Roy,
sure! The problem is that statements inside of stored procedure in MySQL should be delimited using ";". I do not know if I can change inner delimiter for MySQL. There is code:
DROP PROCEDURE IF EXISTS `ats`.`p_ins_rdata`
;
CREATE DEFINER = 'ATS'@'%'
PROCEDURE ats.p_ins_rdata(
IN _symbol varchar(16),
IN _value INT
)
BEGIN
DECLARE object_id int
;
... some more code ...
END
;This code is executed as follows:
1. DROP PROCEDURE IF EXISTS `ats`.`p_ins_rdata`
2. CREATE DEFINER = 'ATS'@'%'
PROCEDURE ats.p_ins_rdata(
IN _symbol varchar(16),
IN _value INT
)
BEGIN
DECLARE object_id int
3. ...
2-nd point giving an error, what is not surprising.
Best regards, Kirill
2009/12/23 Roy Ganor
<roy@xxxxxxxx>
Hi Kirill,
MySql scrapbook uses the generic SQL parser, and the default
delimiter is “;”.
Can you provide a sample of your script so it will be easier to
pinpoint the problem?
Regards,
Roy
Hi All,
I am new to Eclipse DTP. I am trying to make a simple MySQL 5.1 database using
it and fail to create simple stored procedure.
The problem is that I cannot change default Delimiter. Does anyone know how and
where I can change it?
Best regards, Kirill
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev