All Questions
Tagged with java stored-procedures
6 questions
0
votes
1
answer
245
views
What is the format of EXTERNAL NAME argument?
When a Java class cl with a method mth resides in a package pck, what should I put into the EXTERNAL NAME clause of CREATE PROCEDURE?
I tried
CREATE PROCEDURE mth (arg1 INTEGER) LANGUAGE JAVA EXTERNAL ...
- 37
1
vote
0
answers
616
views
Encrypt through Java and Decrypt through SQL Server AES 256
Am trying to insert some value through JAVA Application with AES Algorithm and need to decrypt the data from the SQL Procedure and need to process a data.
Which is the best practice to do so?
- 21
0
votes
1
answer
653
views
Retrieving data from stored procedure's cursor
I want to use the ResultSet in java program to get data from Stored procedure's cursor. Is that possible with SQL Server?
My code:
CREATE PROCEDURE dbo.SampleProcedure AS
DECLARE @FirstName ...
- 115
4
votes
2
answers
2k
views
Database-agnostic stored procedure call passing array of name/value pairs
Background
Looking to pass a set of name/value pairs into a stored procedure in a database-agnostic way, using JDBC. A database structure is defined as follows:
CREATE TYPE array_parameters AS (
...
- 833
1
vote
1
answer
10k
views
Error calling stored procedure from trigger in Oracle Database 11g
I'm trying to create a trigger that calls some Java code whenever a table is inserted/updated. I'm aware of possible performance issues, I don't need advice that I should not do this; I just need to ...
- 361
2
votes
1
answer
1k
views
Preloading a Java library in DB2, similar to ORACLE's loadjava
Edit to add details to clarify, based on Chris' comment:
A Java stored procedure depends on external libraries. Locally it compiles successfully, since they are added to the classpath. But when ...
- 273