Error while creating a procedure

[Former Member]

Hi Experts,

         I'm a bit new to SQLScripting and trying to explore the language syntax.  I'm taking a simple example of a procedure where i select 3 fields of LFA1 table for country = 'US'.  But i get below error while creating procedure.  Could you please guide where i'm going wrong.

create type t_lfa1 as table

(

   lifnr nvarchar(10),

   name1 nvarchar(38),

   adrnr nvarchar(10)

);

create procedure t_test1

( out t_out1 "EC2SLT2"."T_LFA1")

language sqlscript as

begin

    t_out1 = select lifnr name1 adrnr from "EC2SLT2"."LFA1"

             where land1 = 'US';

end;

ERROR:

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "adrnr": line 5 col 33 (at pos 123)

[former_member182302 · Accepted solution]

Please use comma in your SELECT Query

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

How stupid of me.... thanks Krishna.