topic Re: SQL error 1008 occurred when executing EXEC SQL. in Application Development and Automation Discussions

SQL error 1008 occurred when executing EXEC SQL.

Former Member — Tue, 27 Sep 2005 09:09:34 GMT

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

Re: SQL error 1008 occurred when executing EXEC SQL.

eddy_declercq — Tue, 27 Sep 2005 09:14:27 GMT

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

Eddy

Re: SQL error 1008 occurred when executing EXEC SQL.

Former Member — Tue, 27 Sep 2005 09:26:32 GMT

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

Re: SQL error 1008 occurred when executing EXEC SQL.

Former Member — Tue, 27 Sep 2005 09:34:31 GMT

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

Re: SQL error 1008 occurred when executing EXEC SQL.

Former Member — Tue, 27 Sep 2005 09:57:00 GMT

Re: SQL error 1008 occurred when executing EXEC SQL.

eddy_declercq — Wed, 28 Sep 2005 06:10:46 GMT

Hi,

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

Eddy