 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Sep 2003 @ 14:27:41 GMT
| Subj: | | Re: Stored Procedure parms |
| |
| From: | | Dieter Noeth |
Narayan Murthy K S wrote:
| | There is a restriction on what(SQL Statement type) can be used as parameter w.r.t to the Stored procedure DBC.SysExecSql - one major
guy is the SELECT statement(which is not allowed). This also places a restriction on the use of an INSERT-SELECT statement because here
again you have the SELECT in picture. | |
INSERT/SELECT works fine, because it doesn't return a result set.
Dieter
| |
