How can we help you today?
dbviscmd problems with create procedure and ;
1 Comment
Roger Bjärevall
said
almost 6 years ago
Jonas,
Here is one workaround you may try:
@delimiter ++;
create procedure get_referenced_tables()
returning multiset(row(sid integer,
tabname varchar(128)) not null);
---
--
return x_return_value;
@delimiter ;++You find all 3 options in the users guide:
http://confluence.dbvis.com/display/UG100/Executing+Complex+Statements
Regards
Roger
Jonas Andersson
I am trying to create a stored procedure using dbviscmd
like:
create procedure get_referenced_tables()
returning multiset(row(sid integer,
tabname varchar(128)) not null);
---
--
return x_return_value;
----------------------------------------------------------------------------
end procedure;
But it seem like dbviscmd is sending each line ending with ; to the database. one after the other. Is there a way of controling that. So the full create procedure script is sent to the DB in one go. So the DB can succefully create the procedure?