Originally posted by Shailesh Chandra:
<hr></blockquote>
You can use stored procedure in java IFF it works on your DataBase on the first place.
Not sure about SQL Server but if it were oracle the your procedure wouldn't have compiled. It would have given error like INTO clause is expected in this SELECT statement
your procedure shpuld be like
here VAR1,VAR2 are variable defined as COl1 and COl2 type. Also in order to retrun some output from procedure us should have some out arguement to hold output.
If you are planning to return multiple rows from procedure then your out type would be a 'REF CURSOR'
Shailesh[/QB]