Marc Henselewski wrote
>When I try to create a stored procedure I get an error "-5015 Missing
>keyword:IN". It is the first time I use stored procedures with sapdb, so
>please be patient with me if there are simple mistakes. :)
>I tried to do this:
>create dbproc web_user.get_link_list (in p_user_ik integer, out p_link_list
>varchar(2000)) as
> var v_link_list varchar(2000);
> var v_url varchar(2000);
> try
> select url from web_user.hb_web_links where hb_ma_ik = p_user_ik;
> while $rc = 0 do begin
> fetch into :v_url;
> set v_link_list = '<a href="' + v_url + '">' + v_url +
'</a><br>';
> end;
> catch
> if v_link_list is not null set p_link_list = v_link_list;
> else set p_link_list = 'Keine Links vorhanden';
>Thanx for any help.
Please change your procedure as follows :
create dbproc get_link_list (in p_user_ik integer, out p_link_list
varchar(2000)) as
var v_link_list varchar(2000);
v_url varchar(2000);
try
select url from web_user.hb_web_links where hb_ma_ik = p_user_ik;
while $rc = 0 do begin
fetch into :v_url;
set v_link_list = '<a href="' & v_url & '">' & v_url &
'</a><br>';
end;
catch
if v_link_list is not null then set p_link_list = v_link_list
else set p_link_list = 'Keine Links vorhanden';
I have made the following changes :
1. omitted owner specification (web_user). Specification is not possible yet
2. removed second keyword VAR before declaration of v_url
3. used operator & for string concatenation
4. inserted keyword THEN into last <if statement>
5. removed ; before keyword ELSE
Thomas
---
Thomas Anhaus
SAPDB, SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
