ANDYtyara
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: JDBC Stored Procedure Call
Hi Shruti, Create one java class file which would establish connection between JDBC and your DB. Make jar file of this class and put it in SOAPUI bin/ext folder. Use this class in groovy step to establish connection with DB and then call store procedure with syntax as {call SCHEMA_NAME.PACKAGE_NAME.STORE_PROCEDURE_NAME(?,?,?,?,?,?,?,?,?,?,?,?)}"; WHERE ?= IN and OUT parameters shruti wrote: I want to call the store procedure using SOAP UI. I am using Oracle database. I tried to call the procedure through Groovy script and JDBC also but I am not able to call store procedure using both . My store procedure name TEST1 .It consists two parameters . One input parameter and output parameter. CREATE procedure test1(abc in varchar,result out varchar) is begin insert into tst1 values(abc); dbms_output.put_line(result); end; I tried following syntax using JDBC: 1st Try : @declare @param1 varchar(50) @set @param1 := 'XXX' @exec client..TEST1 @param1 2nd Try : execute TEST1('SAM',result) 3rd Try: DECLARE ABC VARCHAR2(32767); BEGIN ABC := 'Testing'; EMAPP.TEST1 ( ABC ); COMMIT; END; I used following combination through Groovy script 1st : sql.call("{?=call TEST1(?)}",[sql.VARCHAR,'SHRUTI']) {result -> assert result=='OUTPUT'} 2nd : def first = 'Sam' sql.call("{$Sql.VARCHAR = call TEST1($first)}") { name -> assert name == 'Sam Pullara' Please suggest me that How I can call the store procedure using groovy or JDBC ? Thanks Shruti3.9KViews1like0CommentsRe: How to call stored procedures from JDBS request test step.
Hi , I called store procedure with input and output parameters and got response us <Results> <UpdateCount>-1</UpdateCount> </Results> What does this UpdateCount ,-1 stands for? Can anyone help me out? Called store procedure with {call Store_Procedure_Name(:InputParameterName,:OutputParameterName)}1.1KViews0likes0CommentsHow to call stored procedures from JDBS request test step.
Hi Team, I am having one oracle store procedure craeted with IN and OUT parameters in ORACLE database. I am trying to call it from SOAP 5.2.1 version with JDBS request test step. Can you please tell me how to call store procedure with input and output parameters? Also do i need to mention all input and output parameters in property list first ? and also how to pass them while calling store procedure? Also how to view DB procedure returned output? It would be helpful if you explain with one example. Your help would be appreciated.695Views0likes0CommentsHow to call stored procedures from JDBS request test step.
Hi Team, I am having one oracle store procedure craeted with IN and OUT parameters in ORACLE database. I am trying to call it from SOAP 5.2.1 version with JDBS request test step. Can you please tell me how to call store procedure with input and output parameters? Also do i need to mention all input and output parameters in property list first ? and also how to pass them while calling store procedure? Also how to view DB procedure returned output? It would be helpful if you explain with one example. Your help would be appreciated.1.2KViews0likes1CommentRe: How to call stored procedures in a datasource step.
Hi Team, I am having one oracle store procedure craeted with IN and OUT parameters in ORACLE database. I am trying to call it from SOAP 5.2.1 version with JDBS request test step. Can you please tell me how to call store procedure with input and output parameters? Also do i need to mention all input and output parameters in property list first ? and also how to pass them while calling store procedure? It would be helpful if you explain with one example. Your help would be appreciated.4KViews0likes1Comment