Skip to main content
197 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
0 answers
320 views

After upgrading to Java 17 and hibernate 6, the sequence of IN parameter was changed. I was able to fix this by changing the sequence while sending the IN parameter to the procedure. But I am ...
tarak mehta's user avatar
  • 21
-1 votes
1 answer
47 views

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 ...
Justanewbie's user avatar
  • 1
0 votes
1 answer
308 views

my repository is as following: @Repository public interface StatisticsRepository extends JpaRepository<CampaignStatisticModel, Integer> { @Procedure(value = "getCampaignStatistics&...
scharrua's user avatar
  • 93
0 votes
1 answer
155 views

Stored Procedure: CALL STORED_PROCEDURE_PROCESS_ONE_TIME(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Stored Procedure Variables: d Stored_Procedure_Process_One_Time_... d pi d xterm ...
lank81's user avatar
  • 49
0 votes
1 answer
810 views

I am trying to get 4 column names from the table which has 10 rows and I want to loop through all rows in that table and pass those column values as parameters into some other stored procedure. How ...
Nanda's user avatar
  • 189
0 votes
2 answers
732 views

I want to use a DB2 stored procedure to run multi insert & update SQL statements from my Java application. I have prepared below procedure that contains error. In this implementation, I first want ...
Elias M. N.'s user avatar
  • 1
1 vote
1 answer
2k views

I am trying to create a Javascript Stored Procedure in Snowflake where the javascript executes a sql query. I am new to javascript and I stole all of it from an existing one that already exists (and ...
Alex Markides's user avatar
  • 61
0 votes
0 answers
365 views

I am trying to run a Stored Procedure which has registered as an external Java Program to Db2. Whenever I call it, I keep getting the error: SQL4304N Java stored procedure or user-defined function &...
rssarkar's user avatar
  • 1
0 votes
0 answers
54 views

I am trying to call the pkg and the procedure in java, as below: public void rebuildIndexes() { Query query = getEntityManager().createNativeQuery("BEGIN BFPA_ARCHIVING....
Klajdi's user avatar
  • 1
1 vote
1 answer
437 views

I have inherited an old Oracle 12c database, which I'm running on a local Oracle 19c server. The database contains the following Java Stored Procedure create or replace and compile java source named ...
simon's user avatar
  • 13k
0 votes
0 answers
776 views

Originally, I was trying to tie together Oracle Database (21c) with RabbitMQ, to enable more efficient microservice communication between the database and a Docker environment (Swarm mode). I found ...
rbl9069's user avatar
  • 23
1 vote
1 answer
3k views

I have a stored procedure which executes multiple queries and for each of those queries I have a try and catch block as shown below. If there is an error, I capture and insert into a LOG table. ...
Nanda's user avatar
  • 189
0 votes
2 answers
532 views

I have a python snippet that I try to port to java. The aim is Gradle but I could not get that to work, so I figured I would start with plain JDBC. The python code looks like this: import argparse ...
Lennart - Slava Ukraini's user avatar
  • 7,211
-1 votes
1 answer
2k views

how pass multiple parameters as DTO or Entity class in arguments method of Repository interface Spring Data i have one procedure that receive multiple parameters of type IN and i have issue with my ...
FreeCode's user avatar
  • 29
0 votes
2 answers
925 views

I am accessing a IBMi running DB2 from a java JVM. I have a stored procedure that returns a CLOB and I want to access the clob from Java. The sql for the stored procedure is: CREATE OR REPLACE ...
Phil Rice's user avatar
  • 41
0 votes
1 answer
707 views

if I have an R script that generates a table and I wanted to insert that into an existing datatable in Snowflake every day, could I automate that using a stored procedure? Is there some functionality ...
S31's user avatar
  • 934
0 votes
0 answers
265 views

I am trying to invoke an Oracle stored procedure , which has a combination of nested Object and tables as below , CREATE OR REPLACE PROCEDURE MYSCHEMA.MY_PROC( p_obj_school IN OUT OBJ_SCHOOL) IS .....
Madhan's user avatar
  • 65
5 votes
0 answers
629 views

I have a stored procedure that is returning results from multiple tables CREATE DEFINER=`root`@`localhost` PROCEDURE `GetProjectAndClientOverview`() BEGIN SELECT ( SELECT count(*) FROM ...
VJain's user avatar
  • 1,069
2 votes
0 answers
2k views

I am using h2 database for running component test case whereas in development postgres is used.Now, function which I created in postgres works fine and business logic as well, but facing issue while ...
Romi Vyas's user avatar
  • 21
1 vote
0 answers
206 views

This is my stored procedure. But there is InvalidDataAccessApiUsageException Entity: @Data @NoArgsConstructor @AllArgsConstructor @Entity @NamedStoredProcedureQuery(name = "app....
Ayshan Rzayeva's user avatar
  • 357
0 votes
1 answer
332 views

Problem statement: snowflake 'get' statement does not work inside a snowflake stored procedure. CREATE OR REPLACE PROCEDURE SP_UNLOAD_DYNAMIC("prefix" varchar) RETURNS varchar(1000) ...
jmobi2121's user avatar
  • 3
1 vote
3 answers
1k views

I have the below Snowflake Javascript Stored procedure where I need to replace multiple instances of a string in an sql statement. CREATE OR REPLACE PROCEDURE MYSCHEMA.CountryDelete(COUNTRY VARCHAR) ...
Sarath Subramanian's user avatar
  • 21.6k
0 votes
0 answers
430 views

Some background: in my app, there are some pdf reports. But, these pdf reports need to be "image" based and I was told that the report server is unable to do this. The call to the report ...
Dejan Dragicevic's user avatar
  • 123
0 votes
1 answer
1k views

Am a bit confused, am trying to call a stored procedures using spring boot JPA. Have created a simple procedure and call the procedure using JPA’s @NamedStoredProcedureQuery annotation. For some ...
arriff's user avatar
  • 449
4 votes
1 answer
2k views

I have tried below code to create tables that listed in tables array, but i get error: JavaScript compilation error: Uncaught SyntaxError: Unexpected end of input in CREATE_TABLES_SP at ' CREATE OR ...
npool's user avatar
  • 121
2 votes
1 answer
5k views

i'm using an Oracle stored procedure in Spring Boot which has some IN/OUT parameters. When i'm getting an out parameter it throws an exception invalidDataAccessApiUsageException: OUT/INOUT Parameter ...
Daniel Fernández's user avatar
  • 53
0 votes
2 answers
258 views

I use ORMLite on a solution made by server and clients. On server side I use PostgreSql, on client side I use SQLite. In code, I use the same ORMLite methods, without taking care of the DB that is ...
Fausto70's user avatar
  • 551
0 votes
1 answer
3k views

There is a code like this: StoredProcedureQuery query = this.em.createStoredProcedureQuery ("NameOfProcedure"); query.registerStoredProcedureParameter ("list_of_ids", Array.class, ...
Vlad's user avatar
  • 1
0 votes
1 answer
405 views

Experts, I am trying to use tables function inside the snowflake procedure. However it throws me an error. CREATE PROCEDURE ..... .... extcnt ="select count(*) from table(information_schema....
gopinath kolanchi's user avatar
  • 180
0 votes
2 answers
1k views

I have been trying to call a java jar file from DB2 stored procedure as external jar. Below is my external jar file code. package connection; public class Connect { static Connection con =...
Vismitha B's user avatar
  • 11
0 votes
1 answer
554 views

We are getting an error message when attempting to create an Oracle db connection from a java stored procedure running within an Oracle database. We have isolated to the connection and it is working ...
Kent Anderson's user avatar
  • 486
0 votes
2 answers
3k views

Question is related to Snowflake and Snowsql. That said I'm trying to within a stored proc create a temp table and then 'copy into' this temp table from azure blob storage. I'm manually executed the ...
junketsu's user avatar
  • 531
0 votes
0 answers
405 views

I have created a Java source and compiled it and wrapped it in an Oracle 19c procedure with the jdk+jre 1.8.0._201. I'm connecting to a suite that uses TLS 1.2 with mutual authentication(with a ...
omarzKH's user avatar
  • 23
0 votes
1 answer
3k views

I am attempting to execute a stored procedure from Spring Batch, the stored procedure has two parameters, an IN parameter and OUT parameter. What I want is to get the result set and the out parameter ...
Saad Yaseen's user avatar
  • 5
1 vote
0 answers
190 views

I have a Spring boot application. I need a feature to dynamically query the stored procedure. What I mean by dynamically, @NamedNativeQuery(name = "getCustomFoo", query = "select * from ...
gfg007's user avatar
  • 191
0 votes
0 answers
475 views

I am using Java and Spring Jdbctemplate to hit a stored procedure and fetch the data. This is deployed as war to Weblogic server. Problem I face is the first request is much slower (10 secs) or it ...
Lolly's user avatar
  • 36.9k
0 votes
1 answer
2k views

In my class I have created simple method below. This class also has a main function in it. I am calling getRes() from my DB2 stored proc. public static void getRes() { System.out.println("Start");...
Db2Cramp's user avatar
  • 33
0 votes
1 answer
624 views

I was asked to write a stored procedure for calculating the net salary of the employee if we pass employee Id as a parameter and the formulas were given and the I had to write a Java program for the ...
utkarsh saxena's user avatar
  • 1
4 votes
1 answer
3k views

Being new to Snowflake I am trying to understand how to write JavaScript based Stored Procedures (SP) to take advantage of multi-thread/parallel processing. My background is SQL Server and writing SP, ...
Paul Grubb's user avatar
  • 41
1 vote
2 answers
2k views

I have a CLOB column that stores html code. To parse it, I've written a Java stored function - CREATE or replace FUNCTION parse_html(value in CLOB) RETURN CLOB AS LANGUAGE JAVA NAME 'MyClass....
Erfan Ahmed's user avatar
  • 1,633
0 votes
1 answer
204 views

I am trying to connect to a remote oracle database in java stored procedure in a traditional way. I am able to call the java stored procedure successfully. But I receive the exception "Missing In or ...
javapsy's user avatar
  • 89
0 votes
1 answer
217 views

We manage a java application that allows to select lines by setting boxes and validate. I want to create a second process to reproduce the same actions of the java application but in shell. Looking ...
DavidOl's user avatar
  • 1
0 votes
2 answers
654 views

I am trying to call procedure from java spring boot. I am passing array as a parameter to procedure and from the procedure I want to return the list back to java as a resultset. Please let me know ...
Dikshit's user avatar
  • 1
0 votes
1 answer
1k views

[dbo].[GetUserCredentials] @Company varchar(255), @SchedType varchar(255), @ShiftHours varchar(255), @UserRole varchar(255), @UserDesc varchar(255), @UserOwner varchar(255) select ......
Dave Marasigan Cheever's user avatar
  • 5
0 votes
1 answer
1k views

I need to find out the Windows username using SQL, PL/SQL or Java. So far I've found some java code that can return a Windows username. I put the Java code in my schema database, but can't create a ...
Developer21's user avatar
  • 13
0 votes
1 answer
239 views

I have loaded the class file of a java program (that fetches data from an excel file and pushes it to a database and making connection to database using values from properties file) into the SQL ...
kaursukhmeet's user avatar
  • 1
0 votes
1 answer
2k views

How do I find the ssl certificate path? That one installed by VisualStudio, to be more expecific when we use .NET Core and run "dotnet dev-certs https --trust" at the console... Could you guys help ...
Renan Leme's user avatar
  • 1
1 vote
1 answer
708 views

I'm working with CosmosDB stored procedure and user defined function. I have to write a stored procedure that return the max of four fields of a collection. In Sql I write: SQL MAX(A) AS ...
Simone Spagna's user avatar
  • 652
0 votes
1 answer
918 views

I'm looking to MSDN how to write a stored procedure in CosmoDB. I find the following simple example : var helloWorldStoredProc = { id: "helloWorld", serverScript: function () { var ...
Simone Spagna's user avatar
  • 652
0 votes
1 answer
2k views

I am setting up a Java Spring project with multiple StoredProcedures to two completely different Oracle databases. It is not allowed to use any auto-generated SQL. I didn't find anywhere a complete ...
davrog10's user avatar
  • 91

1
2 3 4