Questions tagged [stored-procedures]
A subroutine available to applications accessing a relational database system.
stored-procedures
37,137
questions
0
votes
0
answers
32
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 ...
0
votes
1
answer
11
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 ...
0
votes
0
answers
19
views
Crystal Report is loading but not displaying any data
I implimented a code to load the crystal report using web API call in my windowform application.
Below has my report load event. fromDate, toDate, profileId are the user input parameter to execute the ...
0
votes
0
answers
21
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
37
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
50
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
30
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
30
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
63
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
@...
0
votes
2
answers
33
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 ...
0
votes
1
answer
61
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 ...
-1
votes
0
answers
46
views
SQL Server query UPDATE different behavior in SSIS vs SSMS [closed]
I have a function to return SHA2_256.
CREATE FUNCTION [dbo].[Checksum_SHA_256]
(@Input NVARCHAR(100))
RETURNS BINARY(32)
AS
BEGIN
RETURN HASHBYTES('SHA2_256', @Input)
END
I have an UPDATE ...
-1
votes
0
answers
18
views
Fail to convert to internal representation: at oracle.sql.ARRAY.toARRAY(ARRAY.java:301)
Following is the store proc
CREATE OR REPLACE TYPE nested_object as object(
link varchar(3),
name varchar(6)
);
CREATE OR REPLACE TYPE nested_type AS TABLE OF nested_object;
create or replace ...
0
votes
1
answer
39
views
Two PUBLIC Views in Stored Procedure - One Succeeds, One Errors?
If user A creates a view and grants READ on it to PUBLIC.
SQL>create view A.a_public as select 3 id from dual;
View created.
SQL>select * from A.a_public;
ID
----------
3
SQL&...
-1
votes
0
answers
29
views
POWER BI with Stored Procedures
How to connect power bi to oracle stored procedure, so that the result as an output refcursor from my procedure shall be used to visualize the data as a chart in power bi