Questions tagged [stored-procedures]
A subroutine available to applications accessing a relational database system.
stored-procedures
37,141
questions
0
votes
1
answer
43
views
How to update a SQL column in a stored procedure if the column was added?
I have a stored procedure where I select records from a table and I added a column for a flag (ReviewedFlag).
If I need to update this field how can I do it outside of the stored procedure? I need to ...
0
votes
0
answers
35
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
38
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
31
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