>
>rusanov wrote :
>>
>>I update my database from 7.5.00.23 to 7.6.00.10
>>
>>I have problem with my function LAB.getAtomId,
>>
>>I call function and I have error Numeric value out of range;-3019
>>POS(1) Invalid exponent
>>
>>if I call select LAB.getAtomId('laboratory') from DUAL
>function succeed
>>
>>why ? in version 7.5.00.23 it worked.
>>
>>CALL LAB.add_event2
>>( 'info'
>>, 'add_laboratory'
>>, 'N/A'
>>, '11'
>>, LAB.getAtomId('laboratory')
>>, 11
>>)
>>
>>if I call
>>
>>CALL LAB.add_event2
>>( 'info'
>>, 'add_laboratory'
>>, 'N/A'
>>, '11'
>>, 1
>>, 11
>>)
>>
>>call succeed.
>>
>>my function
>>
>>CREATE FUNCTION LAB.getAtomId
>> ( name VARCHAR
>> )
>>
>>RETURNS INT AS
>>
>>TRY
>>
>> IF name = 'test' THEN
>> RETURN 1;
>>
>> IF name = 'technique' THEN
>> RETURN 2;
>>
>> IF name = 'reagent' THEN
>> RETURN 3;
>>
>> IF name = 'producer' THEN
>> RETURN 4;
>>
>> IF name = 'laboratory' THEN
>> RETURN 5;
>>
>> IF name = 'device' THEN
>> RETURN 6;
>>
>> IF name = 'unit' THEN
>> RETURN 7;
>>
>> IF name = 'lot' THEN
>> RETURN 8;
>>
>> IF name = 'service' THEN
>> RETURN 9;
>>
>> IF name = 'profile' THEN
>> RETURN 10;
>>
>> IF name = 'patient' THEN
>> RETURN 11;
>>
>> IF name = 'scheduled_profile' THEN
>> RETURN 12;
>>
>> IF name = 'scheduled_test' THEN
>> RETURN 13;
>>
>> IF name = 'device_instance' THEN
>> RETURN 14;
>>
>> RETURN NULL;
>>
>>CATCH
>> STOP ($rc, $errmsg);
>>
>>CREATE DBPROC LAB.add_event2
>> ( IN type VARCHAR(10)
>> , IN event VARCHAR(50)
>> , IN source VARCHAR(50)
>> , IN comment VARCHAR(2000)
>>
>> , IN atom INT
>> , IN obj INT
>> )
>>
>>AS
>>
>>VAR node VARCHAR(50);
>>SET node = 'N/A';
>>
>>BEGIN
>>
>> TRY
>> SELECT APPLNODEID
>> FROM SYSDBA.TRANSACTIONS T, DOMAIN.CONNECTPARAMETERS C
>> WHERE T.SESSION = C.SESSION;
>>
>> FETCH INTO :node;
>> CATCH
>> IF $rc <> 100 THEN STOP($rc, $errmsg);
>>
>> TRY
>> INSERT LAB.eventlog
>> ( source
>> , type
>> , event
>> , event_user
>> , computer
>> , event_time
>> , comment
>> , atom
>> , obj_id
>> )
>> VALUES
>> ( :source
>> , :type
>> , :event
>> , USER
>> , :node
>> , timestamp
>> , :comment
>> , :atom
>> , :obj
>> );
>> CATCH
>> STOP($rc, $errmsg);
>>END;
>>
>>
>>--
>>MaxDB Discussion Mailing List
>>For list archives: http://lists.mysql.com/maxdb
>>To unsubscribe:
>>http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>
>There's a bug in the code of the call statement, which may produce such
>errors, if call parameters are value expressions. In your case this
>value expression is the call of function getAtomId.
>We will fix this bug as soon as possible.
>
>Best Regards,
>Thomas
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:
>http://lists.mysql.com/maxdb?>[EMAIL PROTECTED]
>
>
I found the following work around :
Please define your function as DETERMINISTIC, i.e.
CREATE FUNCTION LAB.getAtomId
( name VARCHAR
)
RETURNS INT DETERMINISTIC AS ...
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
