Wow, thank you for reply! On Sat, 19 Mar 2005 12:23:43 +0530, Nanda, Sambit K <[EMAIL PROTECTED]> wrote: > Only way to extract results from a row returning procedure is through a > sql program.
And how would I do that? What is a sql program? You mean a program in, say, java using JDBC? > > However you can certainly execute procedure from visual sql which do not > return any thing for example a procedure performing some inserts can be > executed from > Visual sql interface. I figured out a way to do it. I insert MESSAGE statement before return statement in procedure, like this: ..... MESSAGE :result; return :result; end; then call procedure not from Visual SQL but form text-based "isql" program. There it prints message in the output. Can I see MESSAGE statement output from procedure in Visual SQL? Or maybe there are other, more advanced SQL tools around? Maybe third-party tools? Ingres Getting Started document says that a product called "Visual DBA suite" is not included in free version of Ingres? What is this suite? Can it perform what I need? If it can we will buy it, because we really need it. Thanks in advance, Best regards, Nicolai _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
