<font color=red>Very Urgrent!! How to call a stored procedure in sybase</font>
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   sabu_vs
Posted On:   Friday, March 1, 2002 07:26 PM

Hi could you pls tell me how can I call a stored procedure in Sybase I hav a stored procedure with name "MID_EXTRACT_FILE" that increments a sequence number and stores it in a tablw with current date. When I call this in the sql prompt ie just typing MID_EXTRACT_FILE The procedure works But when I call this using java I doenot work and even doenot produce any error message My code is below .....creating connection con.... CallableStatement callst=null; try { callst=con.prepareCall("{call MID_EXTRACT_FILE}"); callst.execute(); }    More>>

Hi



could you pls tell me how can I call a stored procedure in Sybase

I hav a stored procedure with name "MID_EXTRACT_FILE"

that increments a sequence number and stores it in a tablw with current date.



When I call this in the sql prompt ie

just typing MID_EXTRACT_FILE The procedure works

But when I call this using java I doenot work and even doenot produce any error message


My code is below



.....creating connection con....

CallableStatement callst=null;



try

{

callst=con.prepareCall("{call MID_EXTRACT_FILE}");

callst.execute();

}

catch(Exception e)

{

out.println("

Error on Callable Statement (Stored Procedure)

"+e+" ");

}

try

{

callst.close();

}

catch(Exception e){}



could you pls tell me what is the problem

I ma using sybase version 11.5


Pls note that nmy procedure doenot accept any parameter



thanks in advance


sabu

   <<Less

Try this

Posted By:   manu_adusumilli  
Posted On:   Saturday, March 2, 2002 05:35 AM

Try this:
con.prepareCall("begin MID_EXTRACT_FILE; end;");






instead of:
con.prepareCall("{call MID_EXTRACT_FILE}");

About | Sitemap | Contact