sorry, the mail before was incomplete!
>>>>
hi
i�ve got two general questions. would be nice if some could give me some
hints.
(1) when do i have to use colons with varia�bles in dbprocs?
create dbproc test (in myval char(30), out dummy_id integer) as
var
myid integer;
begin
set myid = me.dumy_seq.nextval; -- without colons
set dumy_id = myid;
insert into me.dumy values (:myval, :myid); -- colons needed
end;
(2) is there a tabular summary of built-in functions (ansi functions
seems to work) an predefined variables like %rowtyp in oracle available?
thanks in advance
moro
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
