All Questions
9 questions
0
votes
0
answers
94
views
JMeter,JDBC Request,Stored Procedure,Oracle
i need to call this PL\SQL function structured like this:
FUNCTION FunctionName ( p_lang_IN IN SESSIONS.s_lang%TYPE,
p_user_IN IN VARCHAR2,
...
- 1
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
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
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
3
votes
1
answer
1k
views
JDBC cancel Oracle stored procedure call
I have a very complex oracle stored procedure that searches and retrieves some data. The procedure returns an output parameter - an oracle cursor.
I execute the procedure by JDBC:
CallableStatement ...
- 81
0
votes
0
answers
371
views
performance issue for passing array to sql stored procedure in java
I am passing 500 records to procedure using oracle.sql.ARRAY as --.
private Map<String, Object> saveRecords(Object[][] outputTypeArray) {
Map<String, Object> output = null;
...
- 644
9
votes
1
answer
8k
views
in Oracle JDBC is it possible to batch stored procedure calls and retrieve OUT parameters?
I have a stored procedure in an Oracle 11g database like f(a IN, b IN, c OUT).
I want to call it from JDBC in batch mode and then read all the OUT variables.
Is this possible?
I have this so far
...
- 15.9k
2
votes
2
answers
2k
views
How to pass struct with array attribute from Java to SQL stored procedure?
I have some types in Oracle.
create or replace
TYPE r_telefone_cand AS OBJECT (
candidato NUMBER(10,0),
telefone VARCHAR2(15)
);
create or replace TYPE t_telefone_cand AS TABLE OF ...
- 65