Am 21.10.2016 um 17:43 schrieb Sharad Yadav:
and please try user define array collection
Please try to test with a simpler case yourself.
I think PostgreSQL makes no difference between a stored function and a
stored procedure and I don't know how to use a "user defined type" that
is basically equal to an array.
I hope you realise, that this list is run by volunteers and that to get
help you sometimes have to do work yourself.
Regards,
Felix
On Fri, Oct 21, 2016 at 4:42 PM, Sharad Yadav <sharad.yadav9...@gmail.com>
wrote:
please try same with store procedure .don't try with function
On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <felix.schumacher@
internetallee.de> wrote:
Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
sharad.yadav9...@gmail.com>:
please update
What should be updated?
The images you wanted to sent, were stripped and this could not be seen
by us.
I don't have Oracle and I don't have your plsql function and this can't
test your setup.
I think it is up to you to give us more information.
I would try a simpler function - where the user defined type is replaced
by an array and that has a really simple implementation, like the one I
used for postgresql - and see if it is giving the same error.
Regards,
Felix
On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav
<sharad.yadav9...@gmail.com>
wrote:
On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher <felix.schumacher@
internetallee.de> wrote:
The list strips most attachments. Your images were stripped and this
can't be seen.
Felix
Am 20. Oktober 2016 17:06:52 MESZ, schrieb Sharad Yadav <
sharad.yadav9...@gmail.com>:
Getting same exception..
[image: Inline image 1]
[image: Inline image 2]
On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:
Am 20.10.2016 15:55, schrieb Sharad Yadav:
For REF CURSOR ,I am using Parameter value "ResultSet" and
Parameter
type
"OUT -10" and getting correct result.but for Array.not able to
get
any
docs or any help.Please suggest asap
I tried a simple example callable statement using postgresql with
a
function f_array declared ad:
create or replace function f_array(OUT a1 INT[]) AS $$
BEGIN
a1[0]=1;
a1[1]=2;
END;
$$
language plpgsql;
and called that with a JDBC Sampler using
Query Type: Callable Statement
Query: {call f_array(?)}
Parameter values: dummy
Parameter Types: OUT 2003
Variable name: a1
and it worked OK.
I don't have an oracle db at hand, so can't test it.
Regards,
Felix
On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav
<sharad.yadav9...@gmail.com
wrote:
I have specified all parameter and have checked only problem
with
Array
Type.Please let me know how to declare Array as Output
Parameter
value
and
Type
On Thu, Oct 20, 2016 at 12:57 PM, Felix Schumacher
<felix.schumacher@
internetallee.de> wrote:
Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav <
sharad.yadav9...@gmail.com>:
Please find below menytioned response that we are getting
from
store
procedure
ORA-06553: PLS-306: wrong number or types of arguments in
call to
'P_GET_SUMMARY_DETAILS'
Have you specified all parameters? Is there anything more in
the
JMeter
logs?
Even tough, I suspect you get more problems, when you have
solved
this
first step and want to access the results as an array.
Regards,
Felix
also find belwo mentioned store procedure body
procedure p_get_summary_details(p_application_id in
xxfe_application_summaries.id%type,
p_application_summary out
xxco_alg_appl_summary_t_type,
p_error_code out
number,
p_error_message out
varchar2);
Calling from Java is working fine as below mentioned
String getDBUSERByUserIdSql = "Call
OASPK014.P_GET_SUMMARY_DETAILS(?,?,?,?)";
dbConnection =getDBConnection();
callableStatement =
dbConnection.prepareCall(getDBUSERByUserIdSql);
callableStatement.setBigDecimal(1, new
BigDecimal(applicationId));
callableStatement.registerOutParameter(2,
java.sql.Types.ARRAY,"XXCO.XXCO_ALG_APPL_SUMMARY_T_TYPE");
callableStatement.registerOutParameter(3,
java.sql.Types.INTEGER);
callableStatement.registerOutParameter(4,
java.sql.Types.VARCHAR);
System.out.println(":::Array
Value:::::::"+java.sql.Types.ARRAY);
System.out.println(":::INTEGER
Value:::::::"+java.sql.Types.INTEGER);
System.out.println(":::VARCHAR
Value:::::::"+java.sql.Types.VARCHAR);
System.out.println(":::VARCHAR
Value:::::::"+OracleTypes.CURSOR);
callableStatement.executeUpdate();
Integer errorCode = (Integer) callableStatement.getInt(3);
String errorMessage = (String)
callableStatement.getString(4);
Object[] data = (Object[]) ((Array)
callableStatement.getObject(2)).getArray();
On Thu, Oct 20, 2016 at 11:01 AM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:
Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav <
sharad.yadav9...@gmail.com>:
HI,
Not able to set Parameter values and Parameter types for
Return
type
of
OracleTypes.ARRAY by store procedure.Please give some
suggestion as
i
have
tried below mentioned options...
Case1
Parameter values:: Array
Parameter types:: OUT ARRAY
Case2
Parameter values:: Array
Parameter types:: OUT 2003
However geeting error in both the cases.
Can you post the errors you get?
Regards,
Felix
------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail:
user-h...@jmeter.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of
the
strong"
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the
strong"
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
