Hi Mark.
Thanks
alot for the prompt reply.. I am able to comeup with a part of the code extending Stored Procedures , but my question here is how am I able to pass the parameters and how am I able to pull the stored procedures is my question..??? I am not sure what else need to added or whats the issue with the code or if I am missing something in the code and wt other classes I need to develop.. Can you please help me to sort out this issue.
Please find the code snippet below..
Thanks Once again for your help,
**************************************************************
public class CallGenericStoredProc extends StoredProcedure {
private static final Log log = LogFactory.getLog(CallGenericStoredProc .class);
private static final
String STORED_PROC_NAME = "PROC_NAME";
public CallGenericStoredProc (DataSource ds) {
super(ds, STORED_PROC_NAME);
declareParameter(new SqlParameter("params", Types.VARCHAR));
compile();
}
public String execute(String params) {
Map inParams = new HashMap();
inParams.put("params", params);
Map outParams = execute(inParams);
if (outParams.size() > 0) {
return outParams.get("params").toString();
} else {
return null;
}
}