trupti.mishra
06-07-2006, 11:43 AM
hi ,
I an a new member to webdevloper.com forum.
I am presently working on JAVA editor which supports execution of sql statements from text area of editor through diff DBSteps.Like DBRead and DBGet step.
DBRead is respnsible for parse the string and send to DB by using some wrapper class and a method testSQl() is responsible for returning the number of rows affected.
DBGetStep is responsible for getting the mapped value from the database and dispaly it at editor, acccording to the query.when we start debugging from DBReadStep then DBGetStep.
Now I am facing problem how to execute stored procedures with all the IN,OUTPUT and INOUT parameters from editor.
Though the existing code uses PreparedStatement ,now it supports execution of stored procedures with IN parameter,with select statement.
If possible my kind request is to send java code for EXECUTING STORED PROCEDURES FROM EDITOR.
Thanks & Regards,
Trupti
I an a new member to webdevloper.com forum.
I am presently working on JAVA editor which supports execution of sql statements from text area of editor through diff DBSteps.Like DBRead and DBGet step.
DBRead is respnsible for parse the string and send to DB by using some wrapper class and a method testSQl() is responsible for returning the number of rows affected.
DBGetStep is responsible for getting the mapped value from the database and dispaly it at editor, acccording to the query.when we start debugging from DBReadStep then DBGetStep.
Now I am facing problem how to execute stored procedures with all the IN,OUTPUT and INOUT parameters from editor.
Though the existing code uses PreparedStatement ,now it supports execution of stored procedures with IN parameter,with select statement.
If possible my kind request is to send java code for EXECUTING STORED PROCEDURES FROM EDITOR.
Thanks & Regards,
Trupti