Archives of the TeradataForum
Message 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: 28 Jun 2020|