It looks like @Procedure expects only one OUT parameter which is binded directly to the method return type… To handle multiple OUT params you can use the JPA API directly: StoredProcedureQuery proc = em.createNamedStoredProcedureQuery(“plus1”); proc.setParameter(“arg”, 1); proc.execute(); Integer res1 = (Integer) proc.getOutputParameterValue(“res1”); Integer res2 = (Integer) proc.getOutputParameterValue(“res2”); …
You almost had it, but better start here plpgsql Some will point that PL/pgSQL is not the only way to write Stored Procedures for PostgreSQL and they will be right (that’s one of the advantages of Postgres), but on the other hand PL/pgSQL is nice and relatively easy to start with.
How are you setting up the SqlParameter? You should set the SqlDbType property to SqlDbType.DateTime and then pass the DateTime directly to the parameter (do NOT convert to a string, you are asking for a bunch of problems then). You should be able to get the value into the DB. If not, here is a … Read more
You should be able to use MySQL’s FIND_IN_SET() to use the list of ids: CREATE PROCEDURE `get_users_per_app` (id_list TEXT) BEGIN SELECT app_id, GROUP_CONCAT(user_id) FROM app_users WHERE FIND_IN_SET(app_id, id_list) > 0 GROUP BY app_id; …
My problem is also that I have cars in generic list List Cars and I want pass this list to stored procedure. It exist elegant way how to do it ? You need to convert your generic list Car to a datatable and then pass it to storedprocedure. A point to note is that the … Read more
Alt + F1 is a good shortcut key for sp_help. sp_helptext is another goodie for getting stored procedure text.
INSERT dbo.DataValue(DateStamp, ItemId, Value) SELECT DateStamp, ItemId, Value FROM dbo.tmp_holding_DataValue AS t WHERE NOT EXISTS (SELECT 1 FROM dbo.DataValue AS d WHERE DateStamp = t.DateStamp AND ItemId = t.ItemId);
Just make a call to RETURN: IF EXISTS (<some condition>) BEGIN // NEED TO STOP STORED PROCEDURE EXECUTION RETURN END This will return the control back to the caller immediately – it skips everything else in the proc.
You should be able query the pg_class table to see if the relname exists. IF EXISTS (SELECT 0 FROM pg_class where relname=”<my sequence name here>” ) THEN –stuff here END IF;
ExecuteUpdate on SQL Query should help you. Sample: ISession session = …. IQuery query = session.CreateSQLQuery(“exec LogData @Time=:time, @Data=:data”); query.SetDateTime(“time”, time); query.SetString(“data”, data); query.ExecuteUpdate();