Questions tagged [stored-procedures]
A subroutine available to applications accessing a relational database system.
stored-procedures
37,141
questions
0
votes
0
answers
29
views
db2 procedure inconsistent?
currently facing a very strange problem. when i try the following, i get some rows returned, as expected:
call "clm".MY_PROCEDURE('M00894761','','M_OM','BP_00000858_OM','0','...
- 51
0
votes
1
answer
35
views
How to call a variable inside dynamic SQL Query in Snowflake stored procedure
Need help to call variable inside snowflake stored procedure. It throws a "Missing column specification" - how to access variable allcols inside dynamic SQL in snowflake?
CREATE OR REPLACE ...
- 33
0
votes
1
answer
29
views
PostgreSQL Trigger Procedures Asynchronously From Main Overall Procedure
I am currently working on building a pipeline using a PostgreSQL DB hosted by AWS RDS. In my pipeline, I have a stored procedure in PostgreSQL that is triggered by cron and used to executed other ...
- 1,025
0
votes
0
answers
12
views
Stored procedure error in Synapse Analytics pipeline for SQL serverless pool
I have created a stored procedure inside ForEach pipeline in Azure Synapse Analytics. When I run the pipeline, I get this error:
"errorCode": "2011",
"message": "...
0
votes
0
answers
52
views
Performance improvement: Azure Synapse stored procedure
I need suggestions on the stored procedure, it basically compares the live data with the backup data based on some condition(s).
So difference = (A-B) + (B-A)
Here's my attempt: my idea is to store ...
- 23
0
votes
1
answer
14
views
Error calling Redshift stored procedure with refcursor parameter
I am trying to fetch resultset in DataGrip console from a Redshift stored procedure. Here is my stored procedure body
CREATE OR REPLACE PROCEDURE test_schema.get_redshift_table_ddl(
p_schema_name ...
- 327
0
votes
0
answers
22
views
Crystal Report is loading but not displaying any data
I implemented code to load the Crystal Report using a Web API call in my Windows Forms application.
Below is my report load event. fromDate, toDate, profileId are the user input parameters to execute ...
0
votes
0
answers
23
views
Getting DB2 stored procedure output parameter using symfony and doctrine
I am refactoring plain PHP code in symfony (5) + doctrine
my mode is something like:
$sql = "CALL my_store_procedure (?, ?, ?, ?, ?)";
$stmt = db2_prepare($db, $sql);
$p1 = "p1&...
-1
votes
0
answers
38
views
Convert datetime2(7) from 2012-07-29 10:53:33.0100000 to 29/07/2012 10:53:33 into my stored procedure
I need to convert datetime2(7) from 2012-07-29 10:53:33.0100000 to 29/07/2012 10:53:33 in my stored procedure in SQL Server.
I have this problem with t888_fecact and t888_feciof.
I tried this, but ...
-1
votes
1
answer
51
views
Select maximum values and indicate the time (hour) [closed]
When I run this SQL script:
WITH MaxValues AS
(
SELECT
Par.CodEst AS 'BNA',
Est.GLS_ESTACION AS 'ESTACION',
Par.FecMed,
DAY(Par.FecMed) AS 'DIA',
MONTH(...
-1
votes
1
answer
31
views
Multiple tables as output parameters in Procedure using hibernate
CREATE OR REPLACE PACKAGE BODY Pkg_name
IS
PROCEDURE proceure_Name (
Id IN Long,
startDate IN DATE,
EndDate IN DATE,
Table1 OUT Table1_Name%ROWTYPE,
Table2 OUT ...
0
votes
0
answers
32
views
Handling Varbinary Datatype in Node.JS API header with SQL Server
The API program didn't accept a varbinary format for my Node.JS API with a header key and varbinary value to authenticate my API request with Node.JS.
I've tried the straightforward approach by ...
0
votes
1
answer
66
views
Prevent Insert in stored procedure from being rolled back by caller
I created a stored procedure with an insert like this:
CREATE PROCEDURE MyProcedure
@Param1 varchar(50)
@Param2 varchar(50)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO MyTable
@...
- 1
0
votes
2
answers
35
views
Search and replace strings in text fields in all tables in MariaDB database, based on a table with original strings and their respective replacement
I have a large database, and in it there are several tables with different variants of text fields (VARCHAR, LONGTEXT, MEDIUMTEXT etc).
In these text fields there are sometimes a link to a video on ...
- 1
0
votes
1
answer
71
views
Dynamic SQL and cursor iteration in Snowflake
I've been sitting all weekend, trying to figure out the implementation of cursor iterations in Snowflake procedure blocks.
The goal is to create a dynamic procedure that when called checks all ...
- 15