SQL error 1008 occurred when executing EXEC SQL.

[Former Member]

I'm running a native sql statement on the database and do have the following error.

code is like this :

DATA : LANG(2).

LANG = SY-LANGU .

EXEC sql.

select id, nm

into :gw_street_alias-id, :gw_street_alias-nm

FROM street_alias@urbis

where street_id = :gw_street-id and

lang = :LANG

ENDEXEC.

Structure are the same within SAP and Oracle.

does anyone have any idea???

rewards promised

[Former Member]

Hi,

Pls don't forget to reward points and close the question if you find the answers useful.

Eddy

[eddy_declercq]

Hi, pls check http://help.sap.com/saphelp_webas620/helpdata/en/8a/ea365a4b46e94b9a48f9cfc4c7ed4f/content.htm

Eddy

[Former Member]

Hi,

Thanks for the answer but I'm sure all is the same.

I'm selecting only one column really don't know what happens

[Former Member]

Here is the table street_alias

SQL> desc street_alias@urbis

Name Null? Type

-

---

-

---

-

---

ID NOT NULL VARCHAR2(7)

LANG NOT NULL VARCHAR2(2)

NM NOT NULL VARCHAR2(20)

STREET_ID NOT NULL VARCHAR2(8)

event this code does not work

DATA : lw_possv LIKE LINE OF gi_possv.

DATA : langu(2).

data : id(8).

id = gw_street-id .

langu = sy-langu .

EXEC sql.

select *

into :gw_street_alias

FROM street_alias@urbis

where street_id = '10801146' and

lang = :langu

ENDEXEC.

What's theproblem??? :s

[Former Member]

UP

[eddy_declercq]

Hi,

Pls don't forget to reward points and close the question if you find the answers useful.

Eddy