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
and please try user define array collection
On Fri, Oct 21, 2016 at 4:42 PM, Sharad Yadav
wrote:
> please try same with store procedure .don't try with function
>
> On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher internetallee.de> wrote:
>
>>
>>
>> Am 21. Oktober 2016 11:18:34 MESZ, schrieb S
please try same with store procedure .don't try with function
On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:
>
>
> Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
> sharad.yadav9...@gmail.com>:
> >please update
>
> What should be updated?
>
Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav
:
>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
please update
On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav
wrote:
>
>
> On Thu, Oct 20, 2016 at 4:13 PM, 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, sc
On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher <
felix.schumac...@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 sa
this is a below mentioned procedure
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,
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
:
>Getting same exception..
>
>
>[image: Inline image 1]
>
>
>
>
>
>[image: Inline image 2]
>
>On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher <
>f
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
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
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
On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav
wrote:
> I have specified all parameter and have checked only prob
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.schumac...@internetallee.de> wrote:
>
>
> Am 20. Oktober 2016 13:18:46 MESZ, schrieb
Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav
:
>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 t
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'
also find belwo mentioned store procedure body
procedure p_get_summary_details(p_application_id in
xxfe_application_sum
Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav
:
>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
>
>Param
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:
16 matches
Mail list logo