i'am running a 7.4.3.14 database-server on linux, but i don't
think that my problem depends to any enviroment specific. The
problem is that dbproc's has a little different behavior than
in db2 or oracle. In my case i create an procedure with the
following:
create dbproc GoForIt(out sum integer)
AS
VAR i1 integer;
BEGIN
select id from IdTable;
while $rc = 0 do
BEGIN
FETCH INTO i1;
SET sum = sum + i1;
END;
END;
This isn't realy useful but to enought for demostrate the problem:
If I create this procedure i get back:
General error;-8031 POS(113) Owner must be specified.
This is quite easy to solve i had to write:
select id from MYDBUSER.IdTable;
instead of
select id from IdTable;
But in my context i didn't know the name of MYDBUSER. With db2
or oracle if no user is specified the current user is used
and everything is fine, In sapdb I have to specify the user.
I tried around with get_owner() but than i have dynamic sql(execute)
in my procedure which increases the complexity without any
need of it. Is there a way around these unlikely behavior
difference?
To solve these Problem on my site i have to parse the sql
before it is transfered to the db in my application an add the
username to the sql. This is very unattractive solution.Thanx
Meno
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
