delimiter |

[Siemel Naran]

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.

[Siemel Naran]

"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").

[Siemel Naran]

"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").