Skip to Content
0
Aug 06, 2015 at 10:11 AM

Syntax error---Procedure

17 Views

Hi,

Sorry for silly question. But i was going through SQL documentation with below example.

Any suggestions.

CREATE PROCEDURE exampleExplicit (OUT outTab TABLE(n int)) LANGUAGE SQLScript READS SQL DATA AS

BEGIN

DECLARE temp TABLE (n int);

temp = SELECT 1 as n FROM DUMMY ; BEGIN

DECLARE temp TABLE (n int);

temp = SELECT 2 as n FROM DUMMY ; outTab = Select * from :temp;

END;

outTab = Select * from :temp; END;


Error: incorrect syntax near "(":


BR

Sumeet