Archives of the TeradataForum

Message Posted: Tue, 30 Jul 2002 @ 10:27:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

hi

im trying to create a stored procedure as follows.I wrote this procedure after verifying syntax from teradata help pdf file

CREATE PROCEDURE divaProc (IN num integer,
IN name char(10))
BEGIN
INSERT INTO divas (num,name)
VALUES (:num, :name);
END;

im getting the following error
Failure 3706 : Syntax error Invalid SQL statement
what might be the problem
divakar

	<Prev	Next>		<<First	<Prev	Next>	Last>>