Bob_Campbell.ZORRO@gateway.qm.apple.Com (Bob Campbell) (12/05/89)
Quotes from the Ingres release 6 (Dec 88) manual:
"Procedure can be created or dropped in the SQL Termanal Monitor
or within Embedded SQL. Procedures can only be executed from within
Embedded SQL."
"You cannot invoke a procedure Interactively or from inside another
procedure."
Since you can't execute a procedure from isql, I would assume that you
can't dynamicly execute a stored procedure from embedded SQL (if you could
execute it dynamicly from embedded SQL then there would be no good reason
that you can't execute it from isql :-) Given the above statements you
are clearly not as functional as Sybase stored procedures, or did I miss
something?
Sybase stored procedures can also retrieve data. The Sybase model for
retrieving data does not support cursors the way that Ingres and other
brands do and this allows procedures to return the results from one or
more select statements. (I am not saying that I am a big fan of this
implementation, but it does have a few advantages as well as
disadvantages).
I don't have a cute trailer**************
Applelink: BOBC (BOBC@Applelink.apple.com)
Quickmail: Bob Campbell@ZORRO (Bob_Campbell.ZORRO@gateway.qm.apple.com)