You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Vivek Malhotra <ve...@gmail.com> on 2016/02/02 13:38:18 UTC
ORA-06550 and PLS-00103 Error while running Oracle Stored Procedure
in Jmeter
Can somebody help me with the below Jmeter issue I am facing while running
a stored procedure from JDBC Request Sampler.
http://stackoverflow.com/questions/35151082/ora-06550-and-pls-00103-error-while-running-oracle-stored-procedure-in-jmeter
--
*Kind Regards,*
*Vicky*
Re: ORA-06550 and PLS-00103 Error while running Oracle Stored
Procedure in Jmeter
Posted by Vivek Malhotra <ve...@gmail.com>.
Thanks Sagar for help. I have managed to solve this and am able to run
stored procedure from Jmeter now.
Below is what I used in my Query. Note that Query Type was "Callable
Statement"
begin
{CALL create_nxt_test_data(?, ?, ?, ?)}
end;
Also, used below values:
Parameter Values - xxx, yyy, 123, uuu
Parameter Types - Varchar, Varchar, integer, Varchar
Variable Names - BCSIG, CNOTE, UTYPE, DTAP
Result Variable Name: result
Kind Regards,
Vivek
On Tue, Feb 2, 2016 at 2:49 PM, Vivek Malhotra <ve...@gmail.com> wrote:
> Thanks Sagar,
> I have already checked this link yesterday,
>
> Even the guy has mentioned in one of the comments that - It looks like
> you are trying to adopt my tutorial to Oracle database, with witch I have
> very little experience and I won't be able to help you.
>
>
> Aslo, as per the link he says to run the Stored Procedure without any
> begin or end block, like below:
>
> {call create_test_data('000000316F1422C8','N','1','2016-01-28')}
>
> If I try to run this I am getting this error.
>
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'CREATE_TEST_DATA' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> If you need I can share the SP as well, but I think something wrong in
> Jmeter the way I am doing. Below should be the correct way of running SP
> but still its not working.
>
>
> begin
> {call create_test_data('000000316F1422C8','N','1','2016-01-28')};
> end:
>
> Thanks a Lot,
>
> Kind Regards,
> Vivek
>
> On Tue, Feb 2, 2016 at 2:34 PM, SAGAR JISKAR <sa...@gmail.com>
> wrote:
>
>> Hi Vivek,
>>
>> Can you please check for below link,
>>
>> tp://
>>
>> code-ninja.blogspot.com/2014/03/ms-sql-server-load-testing-with-jmeter.html
>>
>> Many Thank
>> Cheers,
>> Sagar Jiskar
>>
>> On Tue, Feb 2, 2016 at 8:38 PM, Vivek Malhotra <ve...@gmail.com>
>> wrote:
>>
>> > Can somebody help me with the below Jmeter issue I am facing while
>> running
>> > a stored procedure from JDBC Request Sampler.
>> >
>> >
>> >
>> http://stackoverflow.com/questions/35151082/ora-06550-and-pls-00103-error-while-running-oracle-stored-procedure-in-jmeter
>> >
>> > --
>> >
>> > *Kind Regards,*
>> >
>> > *Vicky*
>> >
>>
>
>
>
> --
>
> *Kind Regards,*
>
> *Vivek Malhotra**Ph: +49 (0) 151 294 86361
> <%2B49%20%280%29%20151%20294%2086361>*
>
> *P* *Please think before you print . Please consider the environment. We
> have not inherited the environment from our ancestors - We have loaned it
> from our future generations.*
>
>
--
*Kind Regards,*
*Vivek Malhotra**Ph: +49 (0) 151 294 86361*
*P* *Please think before you print . Please consider the environment. We
have not inherited the environment from our ancestors - We have loaned it
from our future generations.*
Re: ORA-06550 and PLS-00103 Error while running Oracle Stored
Procedure in Jmeter
Posted by Vivek Malhotra <ve...@gmail.com>.
Thanks Sagar,
I have already checked this link yesterday,
Even the guy has mentioned in one of the comments that - It looks like you
are trying to adopt my tutorial to Oracle database, with witch I have very
little experience and I won't be able to help you.
Aslo, as per the link he says to run the Stored Procedure without any begin
or end block, like below:
{call create_test_data('000000316F1422C8','N','1','2016-01-28')}
If I try to run this I am getting this error.
ORA-06550: line 1, column 7:
PLS-00201: identifier 'CREATE_TEST_DATA' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
If you need I can share the SP as well, but I think something wrong in
Jmeter the way I am doing. Below should be the correct way of running SP
but still its not working.
begin
{call create_test_data('000000316F1422C8','N','1','2016-01-28')};
end:
Thanks a Lot,
Kind Regards,
Vivek
On Tue, Feb 2, 2016 at 2:34 PM, SAGAR JISKAR <sa...@gmail.com>
wrote:
> Hi Vivek,
>
> Can you please check for below link,
>
> tp://
> code-ninja.blogspot.com/2014/03/ms-sql-server-load-testing-with-jmeter.html
>
> Many Thank
> Cheers,
> Sagar Jiskar
>
> On Tue, Feb 2, 2016 at 8:38 PM, Vivek Malhotra <ve...@gmail.com> wrote:
>
> > Can somebody help me with the below Jmeter issue I am facing while
> running
> > a stored procedure from JDBC Request Sampler.
> >
> >
> >
> http://stackoverflow.com/questions/35151082/ora-06550-and-pls-00103-error-while-running-oracle-stored-procedure-in-jmeter
> >
> > --
> >
> > *Kind Regards,*
> >
> > *Vicky*
> >
>
--
*Kind Regards,*
*Vivek Malhotra**Ph: +49 (0) 151 294 86361*
*P* *Please think before you print . Please consider the environment. We
have not inherited the environment from our ancestors - We have loaned it
from our future generations.*
Re: ORA-06550 and PLS-00103 Error while running Oracle Stored
Procedure in Jmeter
Posted by SAGAR JISKAR <sa...@gmail.com>.
Hi Vivek,
Can you please check for below link,
tp://
code-ninja.blogspot.com/2014/03/ms-sql-server-load-testing-with-jmeter.html
Many Thank
Cheers,
Sagar Jiskar
On Tue, Feb 2, 2016 at 8:38 PM, Vivek Malhotra <ve...@gmail.com> wrote:
> Can somebody help me with the below Jmeter issue I am facing while running
> a stored procedure from JDBC Request Sampler.
>
>
> http://stackoverflow.com/questions/35151082/ora-06550-and-pls-00103-error-while-running-oracle-stored-procedure-in-jmeter
>
> --
>
> *Kind Regards,*
>
> *Vicky*
>