09-27-2005 10:09 AM
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
09-27-2005 10:14 AM
09-27-2005 10:26 AM
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
09-27-2005 10:34 AM
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
09-27-2005 10:57 AM
09-28-2005 7:10 AM
Hi,
Pls don't forget to reward points and close the question if you find the answers useful.
Eddy