470,591 Members | 2,282 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

delimiter |

Hi.

In order to define a procedure I tried changing the delimiter to the
pipe symbol | so that the semicolon ; is not interpreted as end of
command. This idea is in the documentation file manual.txt.
delimiter |

create procedure myprocedure ()
begin
select user();
end
|
But when I type "delimiter |" the system says incorrect syntax. It
doesn't even respond to "delimiter |;" or "delimiter".

Thanks.
Jul 20 '05 #1
2 1452
"Siemel Naran" <na*******@excite.com> wrote in message
In order to define a procedure I tried changing the delimiter to the
pipe symbol | so that the semicolon ; is not interpreted as end of
command. This idea is in the documentation file manual.txt.
delimiter |


The above works correctly in 4.1. However stored procedure are only in 5.0
("1.8.4.4 Stored Procedures and Triggers / Stored procedures are being
implemented in our version 5.0 development tree").
Jul 20 '05 #2
"Siemel Naran" <na*******@excite.com> wrote in message
In order to define a procedure I tried changing the delimiter to the
pipe symbol | so that the semicolon ; is not interpreted as end of
command. This idea is in the documentation file manual.txt.
delimiter |


The above works correctly in 4.1. However stored procedure are only in 5.0
("1.8.4.4 Stored Procedures and Triggers / Stored procedures are being
implemented in our version 5.0 development tree").
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by j-marvin | last post: by
3 posts views Thread by Laurent | last post: by
reply views Thread by paqogomez | last post: by
7 posts views Thread by Generic Usenet Account | last post: by
4 posts views Thread by Raquel | last post: by
4 posts views Thread by kretik | last post: by
11 posts views Thread by Sven Reuter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.