Hi everyone!
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.
Marc
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
