When I set isolation level to serializable it works?! What am I
overlooking?
Regards,
Filip Sergeys
On Tue, 2004-02-17 at 13:19, Filip Sergeys wrote:
> 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]
>
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* 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]
