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?