Index « Stored Procedure « JPA Q&A

1. Hibernate, Stored Procedures and Invalid Parameter Index Error

I have a SQL Server Stored Procedure that looks like this:

CREATE PROCEDURE [dbo].[my_stored_procedure] 
        @num INT,

2. Stored Procedures, scalar return, column by index

Hello, I have a simple stored procedure for SQL Server 2000, that does not take any parameters and returns a scalar value, which is the result of "for XML AUTO" syntax in SQL Server. Basically, it returns rows of String values. The problem is that the column name it assigns to the single column in the result set seems to be ...