You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by rpaliath <ra...@hotmail.com> on 2009/09/22 19:54:33 UTC
Calling a stored procedure
Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
r785646) and hitting all kind of errors. I have been using some posts to try
various combinations:
SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT -10
Variable Names - P_BANK_HOLIDAYS_O
Error Message - ORA-06576: not a valid function or procedure name
SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
Variable Names - P_BANK_HOLIDAYS_O
Error Message - Invalid data type:
<SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT 10
Variable Names - P_BANK_HOLIDAYS_O
Error Message - Invalid column type
Please help.
Thanks.
--
View this message in context: http://www.nabble.com/Calling-a-stored-procedure-tp25530843p25530843.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Calling a stored procedure
Posted by Deepak Shetty <sh...@gmail.com>.
get your SP working from a standard Java client first.
regards
deepak
On Tue, Sep 22, 2009 at 10:54 AM, rpaliath <ra...@hotmail.com> wrote:
>
> Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
> r785646) and hitting all kind of errors. I have been using some posts to
> try
> various combinations:
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT -10
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - ORA-06576: not a valid function or procedure name
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - Invalid data type:
> <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT 10
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - Invalid column type
>
> Please help.
>
> Thanks.
> --
> View this message in context:
> http://www.nabble.com/Calling-a-stored-procedure-tp25530843p25530843.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: Calling a stored procedure
Posted by Deepak Shetty <sh...@gmail.com>.
well then replicate the values into your Jmeter.
for e.g.
In your java client is this "CALL
<SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)"
what you specify in the query for callable statement?
Is "Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type"
what you specify in your type?-- shouldnt this be an integer?
regards
deepak
On Tue, Sep 22, 2009 at 12:42 PM, rpaliath <ra...@hotmail.com> wrote:
>
> I am able to execute this SP from a Java client as well as from an oracle
> client.
>
>
>
> rpaliath wrote:
> >
> > Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
> > r785646) and hitting all kind of errors. I have been using some posts to
> > try various combinations:
> >
> > SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> > (P_BANK_HOLIDAYS_O)
> > Parameter Values - NULL
> > Parameter Types - OUT -10
> > Variable Names - P_BANK_HOLIDAYS_O
> > Error Message - ORA-06576: not a valid function or procedure name
> >
> > SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> > (P_BANK_HOLIDAYS_O)
> > Parameter Values - NULL
> > Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
> > Variable Names - P_BANK_HOLIDAYS_O
> > Error Message - Invalid data type:
> > <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
> >
> > SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> > (P_BANK_HOLIDAYS_O)
> > Parameter Values - NULL
> > Parameter Types - OUT 10
> > Variable Names - P_BANK_HOLIDAYS_O
> > Error Message - Invalid column type
> >
> > Please help.
> >
> > Thanks.
> >
>
> --
> View this message in context:
> http://www.nabble.com/Calling-a-stored-procedure-tp25530843p25530879.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: Calling a stored procedure
Posted by rpaliath <ra...@hotmail.com>.
I am able to execute this SP from a Java client as well as from an oracle
client.
rpaliath wrote:
>
> Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
> r785646) and hitting all kind of errors. I have been using some posts to
> try various combinations:
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT -10
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - ORA-06576: not a valid function or procedure name
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - Invalid data type:
> <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
>
> SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
> (P_BANK_HOLIDAYS_O)
> Parameter Values - NULL
> Parameter Types - OUT 10
> Variable Names - P_BANK_HOLIDAYS_O
> Error Message - Invalid column type
>
> Please help.
>
> Thanks.
>
--
View this message in context: http://www.nabble.com/Calling-a-stored-procedure-tp25530843p25530879.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org