Syntax error---Procedure

[former_member226419]

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

[pfefferf]

Hi Sumeet,

which HANA Revision you use? The inline type declaration is available since SPS09.

Best Regards,

Florian

[former_member226419]

Hi,

I am using version 1.00.80.00.391861. Is that SP 8?

BR

Sumeet

[pfefferf]

Yes, that is SPS08. So you have to upgrade to use that new syntax .

In the blog post of Rich Heilman about SQLScript News for SPS09 it is described:

[Former Member]

Hi Sumeet,

     Yes that would mean SP 8 (80-89)