37,159 questions
-2
votes
0
answers
34
views
MySQL Stored Procedure INSERT INTO a temp table from CTE erroring [duplicate]
I am creating a temp table in a stored procedure to hold the results of a CTE query. Without the temp table the query works fine. The code is below. I keep getting an error at the INSERT INTO line - ...
- 1
1
vote
0
answers
94
views
Passing an array to a stored procedure expecting a SYS.ODCIVARCHAR2LIST
I'm passing an array of strings to an Oracle PL/SQL stored procedure to a parameter that expects SYS.ODCIVARCHAR2LIST on my muleApp stored procedure connector and it throws the following error:
ORA-...
- 33
3
votes
2
answers
251
views
Exception in C# code when trying to call a stored procedure with encrypted param
I have table with an encrypted column UserName:
I also have a stored procedure (in SQL Server) defined as below :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[...
- 4,361
-1
votes
1
answer
135
views
SQL query for retrieving XML nodes parent child nodes [closed]
I have an XML and now I want to retrieve the XML nodes and its values in SQL Server and add it into a SQL Server table.
This is my XML:
<ADN>
<gift>
<giftdetail>
<source&...
-3
votes
1
answer
52
views
How to solve column reference "description" is ambiguous error [duplicate]
This query is called get_all_with_columns(). I am trying to create a procdure which returns 2 columns in PostgreSQL, but I am facing an error.
Here is the procedure with the query:
CREATE OR REPLACE ...
2
votes
3
answers
200
views
SQL Server stored procedure passed a Biztalk XML message not returning field values when parsing the XML text
Our integration team want to send a XML parameter from their Biztalk server containing values to be written to a SQL Server table using a stored procedure, and have sent me an example for me to create ...
- 21
1
vote
1
answer
95
views
Passing Parameters to a User Defined Function from within a Snowflake Stored Procedure
I have an interesting issue with passing parameters to a udf from within a stored procedure. I can pass one parameter and send a valid string value for the second parameter, and it works fine. See ...
- 441
2
votes
0
answers
103
views
LinqToSql float stored procedure param generates string that is too long for double value of 0.820035
I have this stored procedure:
CREATE PROCEDURE [dbo].TestInsert @doubleVal float
AS
BEGIN
INSERT INTO Test (Dubs)
VALUES (@doubleVal);
END
which inserts a SQL float into this table:
CREATE ...
- 1,329
0
votes
0
answers
50
views
Find SQL Server stored procedures that have optional parameters [duplicate]
I am trying to run a query in T-SQL to identify stored procedures that are defined with optional ("defaulted") parameters. I had expected this to be a common thing for people to try and find ...
- 986
0
votes
2
answers
120
views
Stored procedure result truncates at 2033 characters [duplicate]
I am calling a SQL Server stored procedure from C#. It works fine as long as the result is not longer than 2033 characters. If it is longer than 2033 characters, the result is truncated at 2033 ...
- 881
1
vote
1
answer
76
views
Call to an overloaded procedure inside another procedure in an Oracle/PLSQL package
I have a question about this package:
create or replace PACKAGE BODY emp_pkg IS
FUNCTION valid_deptid(p_deptid IN departments.department_id%TYPE)
RETURN BOOLEAN IS
v_dummy PLS_INTEGER;
...
Advice
0
votes
5
replies
75
views
Procedure to show percentage of nulls in TERADATA SQL ASSISTANT
I'm working in Teradata SQL Assistant and I need to create a stored procedure that, given a table name, returns the percentage of NULL values for each column in that table.
Right now, I generate the ...
- 67
1
vote
1
answer
78
views
Redshift : Opening multiple cursors from within the same client connection is not allowed
I have the following procedure written in redshift, which uses 2 for loops to get country code first and then years as per the country codes.
--Procedure : sp_for_loop_test
create or replace procedure ...
- 7,361
0
votes
0
answers
69
views
Redshift - SQL Error: Internal jdbc driver error
I am trying to use for loop within the stored procedure to retrieve the employee id and process further but getting an error:
Error: SQL Error: Internal jdbc driver error
Procedure:
create or replace ...
- 7,361
0
votes
0
answers
72
views
How do I / example of adding source info in IBM MQ Header (possible MQRFH2/usr) from DB2 stored procedure
We have a stored procedure in DB2 written in an external sproc (possibly some mainframe language, possibly C++) that creates an XML structure and puts it on a queue.
I know we can add a correlation id,...
- 3,021