Hello Nicolai, Visual sql interface uses dynamic sql programmes for executing procedures as the error suggests. And Ingres does not support the row returning procedures in dynamic sql. So you cannot execute a row returning procedure from Visual sql. There are no other utilities which could do that for you. Only way to extract results from a row returning procedure is through a sql program.
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. Hope this helps... Regards, Sambit Kumar Nanda Computer Associates Software Engineer, Development tel:+91-40 5567 0409 fax:+91-40 55670001 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nicolai Tufar Sent: Saturday, March 19, 2005 11:41 AM To: [email protected] Subject: [Users] call procedure from Visual SQL Hi all, I was wandering is there a way to see the value returned by a procedure called from Visual SQL interface. I call function like this: execute foo(par1=123, par2=345) Bu how I an see the result? Or maybe there is another utility where I can do that? Please help. Another problem is how to call row returning function form Visual SQL. When I try to call it with "execute" it complains about SQL being dynamic. Thanks in advance, Nicolai _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
