|
Archives of the TeradataForumMessage Posted: Wed, 14 Aug 2002 @ 14:55:58 GMT
According to the manuals, PREPARE is available only in embedded SQL. The following syntax compiles correctly: Create Procedure mfrtest(simno char(10)) When I try to run it, however, I get this error: *** Failure 5568 mfrtest:SQL statement is not supported within a stored procedure. I believe this is because stored procedures cannot return result sets; they can only return a single row of values. If your procedure is fairly simple and you need a result set, you should probably use a macro instead: Create Macro mfrtest(simno char(10))
| |||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | |||||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||||