stored-functions
Fatal Error while calling MySQL stored function from PHP using MySQLi
Server details: PHP v5.3.5 Using MySQLi library client api version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $[详细]
2023-02-16 05:58 分类:问答MySQL geom offset testing
I\'m looking to write an offset function to test in a moving object touches other movable and fixed objects in space.[详细]
2023-02-16 01:28 分类:问答CREATE FUNCTION error "This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA"
Our database has a function to generate an order number. It reads a value from a Settings table, increments it, then returns the new value. For example:[详细]
2023-02-08 19:21 分类:问答How to throw an error in MySql procedure?
What is the mechanism to force the MySQL to throw an error within the stored procedure? I have a procedure which call s another function:[详细]
2023-02-07 17:38 分类:问答How do I return a binary string (bytea) in a PL/Python PostgreSQL routine?
I\'m currently trying to write a procedure in PL/Python to perform a conversion of some data, then return the result as a bytea. (it\'s quite ugly, actually: marshalling the data in OCaml! Ugly in Pyt[详细]
2023-02-07 05:51 分类:问答Entity Framework function/stored proc updates
If i change the the underlying storedproc of a function and update the complex 开发者_开发百科type; does the entire model have to updated as well?I usually just delete the proc from my model, and then[详细]
2023-02-06 09:43 分类:问答Struggling to see the error of my ways (mysql function)
(see my answer below for solution - thanks for the feedback) It\'s probably something really obvious but I can\'t see what\'s wrong with my sql:[详细]
2023-02-05 15:27 分类:问答How do I call an Oracle function to insert data using ODP.NET and a dataset? (specific example)
We\'re really lost on this one, having read the ODP.NET 2 Day+ developer guide hasn\'t helped. I\'ve provided the function definition (stored in a package), I don\'t understand what we have to cast th[详细]
2023-02-05 04:14 分类:问答Issue in adding two outputs from MySQL function inside another function
CREATE DEFINER=`root`@`localhost` FUNCTION `F_GetProjectCostPerEmployeeInProject`(id VARCHAR(20)) RETURNS DECIMAL(30,2)[详细]
2023-02-04 06:56 分类:问答Trying to convert simple execution stored procedure to postgres function - can't get CURRVAL('table_seq') to function
The MySQL Stored Procedure was: BEGIN set @sql=_sql; PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;[详细]
2023-02-03 04:39 分类:问答