Subject | Problem removing UDF |
---|---|
Author | kittikira |
Post date | 2010-01-18T16:08:45Z |
I have a problem, when removing an UDF.
I have an UDF "round", that does axactly the same the internal function round does.
So I want to remove the UDF round, to use the internal function.
I removed it by
drop external function round;
To do so, I had to alter many stored procedures and triggers, for round was used there.
Finally I could drop the external function round.
Now I have a problem when making a backup. Gbak tells me, that the external function round is missing.
The same problem when using b_line_count (an UDF that counts the lines of a text blob). "invalid request BLR at offset 6 function round not defined".
I had to declare the UDF again to get it working.
What could be the reason for this problem=
I have an UDF "round", that does axactly the same the internal function round does.
So I want to remove the UDF round, to use the internal function.
I removed it by
drop external function round;
To do so, I had to alter many stored procedures and triggers, for round was used there.
Finally I could drop the external function round.
Now I have a problem when making a backup. Gbak tells me, that the external function round is missing.
The same problem when using b_line_count (an UDF that counts the lines of a text blob). "invalid request BLR at offset 6 function round not defined".
I had to declare the UDF again to get it working.
What could be the reason for this problem=