All Questions
31 questions
1
vote
1
answer
390
views
executeUpdate() is no working while execute using stored procedure
executeUpdate return 1 but values are not inserted into the table. 'CR_SAVEHBCRPERFORMA ' is the procedure to insert values. output parameter return 1 after execute else 0, here return 0..(some code ...
1
vote
1
answer
828
views
How to call oracle stored procedure in spring using entity manager?
create or replace PROCEDURE TEST
(
Role IN VARCHAR2,
OUTPUT
OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN OUTPUT FOR
Select PC.PRODUCT_NAME,P.PARTNER_NAME
............
.............
WHERE PC....
- 11
0
votes
1
answer
93
views
How to call a plsql procedure with a table type as input parameter in Java?
I have a procedure like
PROCEDURE merge_string_custom_fields(s1_cf IN wf__custom_fields_table, s2__cf IN wf__custom_fields_table, r__cf OUT wf__custom_fields_table);
And I try to call it from my ...
- 1,819
0
votes
0
answers
36
views
Passing list to oracle stored procedure in Java but getting only one element in list type object [duplicate]
I'm passing a list object [1, 2, 3, 4, 5] to Oracle stored procedure by creating a custom type in oracle package as below -
create type index_num_rec as object (index_number varchar2(1000));
create ...
- 13
0
votes
2
answers
963
views
How to Return a Custom Set in PL/SQL Stored Procedure
How can I return a set of data from PL/SQL?
I have a stored procedure that needs to run a select statement and returns the result back to the calling (Java) program.
The select statement comprises ...
- 705
0
votes
1
answer
104
views
Blank Servlet with Stored Procedures
i'm pretty new at programming, so its a bit hard for me x.x, but i'm trying to execute a login(JSP) with a stored procedure on java (servlet), sadly the servlet page only gives me a blank page and ...
- 1
-2
votes
1
answer
3k
views
Pass oracle object type to java stored procedure
Is is possible to pass oracle object type to java stored procedure. Here's what i have so far.
Java stored procedure:
create or replace and compile java source named Example as
import java.sql.SQLData;...
- 754
0
votes
1
answer
2k
views
Empty ResultSet from PL/SQL procedure returning non-empty rows
I'm using JDBC to get Results from an Oracle Stored procedure which is using SYS_REFCURSOR. When I execute the Stored procedure in sqlPlus , I get results , but in Java , I'm getting an empty result ...
- 166
0
votes
2
answers
5k
views
java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support resultsets via stored procedures
how to solve the following error I am using JPA 2.1 widfly Application Server 8.0 and Oracle 11g bd
java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support ...
2
votes
3
answers
9k
views
From Java Passing Values as Array to Database Stored Procedure
I have the following stored procedure in database
CREATE OR REPLACE PROCEDURE my_proc (
my_array IN my_array_type,
my_var IN OUT VARCHAR2)
....
....
In Java I have the ...
- 14.7k
2
votes
1
answer
829
views
Incorrect order of binded params in oracle stored proc called from Java using JDBC callable statement
Following is the oracle proc call from java using binded params -
String GET_TEST_ID = "{call PKG_TEST.prc_gettestid(:PARAM1, :PARAM2, :PARAM3, :OUTPARAM1)}";
String id = (String)getJdbcTemplate()....
- 69.2k
1
vote
1
answer
650
views
Fetch data from database using procedure
I am trying to read data from oracle database by calling procedure from java code.
If I am running the procedure from sqldeveloper, I can see that the procedure is giving me the correct output.But ...
1
vote
1
answer
2k
views
Oracle 11g: Pass array as input parameter to an oracle stored procedure using simple jdbc call
I have the following stored proc:
PROCEDURE test( p_a IN VARCHAR_ARRAY, p_b VARCHAR_ARRAY, p_c IN VARCHAR_ARRAY,
p_d VARCHAR_ARRAY , p_e NUMBER_ARRAY, p_f IN NUMBER_ARRAY, p_Results OUT ...
- 1,753
0
votes
1
answer
3k
views
java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next
I am trying to execute stored procedure in oracle using hibernate.When I call procedure from hibernate the process get called but after that it showing me exception that
ERROR: Cannot perform fetch ...
- 3,434
2
votes
1
answer
172
views
Is it possible to delete multiple delete statements using parallel ? The delete statements are separate queries affecting different tables
I have the follwing proceudre which is designed to delete the data from transaction table to the audit tbles after certaibn days. This will run every night as a batch process :
create or replace ...
- 125