Filip Sergeys wrote :
>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')
>>
Error -4024 means that the cursor 'physdata' could not be found. It seems
that the declare cursor statement inside your procedure didn't produce
the result set, maybe due to an error.
I therefore recommend to check the $rc variable for errors, because otherwise
an error produced by the declare cursor statement will be lost.
IF $RC <> 0 THEN STOP (-31001, 'unexpected error ' || chr($rc));
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
