Hello
I got this (general error -4024) error when trying to execute a stored
procedure that just executes a simple query.
The strange thing is that the query works OK when executed in sqlstudio
but not when embedded in a dbproc
Who can shed some light on this?
Thanks in advance,
Filip Sergeys
This is the dbproc:
create dbproc physdata(IN reqtype char(5)) returns cursor as
$cursor = 'physdata';
declare :$cursor cursor for
select a.requestid as REQUESTID, b1.value as OFFICEID, b2.value as
EMPLOYEEID, c.value as "TIMESTAMP", d.value as TYPE, e.value as
CLIENTNR, g.value as TITLE, h.value as FIRSTNAME, i.value as LASTNAME,
j.value as BIRTHDATE, k.street as STREET, k.streetno as STREETNO, k.zip
as ZIP, k.city as CITY
from delta.t_request a, delta.t_request b, common.t_office b1,
common.t_employee b2, delta.t_request c, delta.t_request d,
delta.t_request e, delta.l_reqentity f, delta.t_physentity g,
delta.t_physentity h, delta.t_physentity i, delta.t_physentity j,
delta.t_address k, delta.t_request l
where b.requestid=a.requestid
and b1.officeid=a.value
and b2.employeeid=b.value
and c.requestid=a.requestid
and d.requestid=a.requestid
and e.requestid=a.requestid
and f.requestid=a.requestid
and g.physentityid=f.entityid
and h.physentityid=f.entityid
and i.physentityid=f.entityid
and j.physentityid=f.entityid
and l.requestid=a.requestid
and num(l.value)=k.addressid
and a.key = 'OFFICEID'
and a.value = '019999'
and b.key = 'EMPLOYEEID'
and b.value = '019999'
and b1.key = 'DESCRIPTION'
and b2.key = 'NAME'
and c.key = 'TIMESTAMP'
and d.key = 'REQUEST_TYPE'
and d.value= :reqtype
and e.key = 'CLIENTNR'
and f.type = 'INST'
and g.key = 'TITLE'
and h.key = 'FIRSTNAME'
and i.key = 'LASTNAME'
and j.key = 'BIRTHDATE'
and l.key = 'INSURETAKER_ADDRESSID';
This is how I call the dbproc:
call physdata('CAR')
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
