Fala pessoal!! blz??
Estou com o seguinte problema:
Não consigo chamar essa stored procedure:
CREATE PROCEDURE px_Atualiza
@vlDia INT
,@vlMes INT
,@vlAno INT
,@vlColuna INT
,@vlHora NVARCHAR(50)
AS
BEGIN
IF @vlColuna<6
BEGIN
DECLARE @strQuery NVARCHAR(2000)
IF EXISTS(SELECT * FROM Horario WHERE DAY(data)=@vlDia AND MONTH(data)=@vlMes AND YEAR(data)=@vlAno)
BEGIN
SET @strQuery = 'UPDATE Horario SET '
IF @vlColuna = 0 SET @strQuery = @strQuery + 'Entrada'
ELSE IF @vlColuna = 1 SET @strQuery = @strQuery + 'SaidaAlmoco'
ELSE IF @vlColuna = 2 SET @strQuery = @strQuery + 'VoltaAlmoco'
ELSE IF @vlColuna = 3 SET @strQuery = @strQuery + 'Saida'
ELSE IF @vlColuna = 4 SET @strQuery = @strQuery + 'ExtraInicio'
ELSE IF @vlColuna = 5 SET @strQuery = @strQuery + 'ExtraFim'
SET @strQuery = @strQuery + ' = '''+@vlHora+''' WHERE DAY(data)='+CAST(@vlDia AS NVARCHAR)+' AND MONTH(data)='+CAST(@vlMes AS NVARCHAR)+' AND YEAR(data)='+CAST(@vlAno AS NVARCHAR)
EXEC(@strQuery)
END
ELSE
BEGIN
DECLARE @data DATETIME
SET @data=CAST(CAST(@vlMes AS NVARCHAR)+'/'+CAST(@vlDia AS NVARCHAR)+'/'+CAST(@vlAno AS NVARCHAR) AS DATETIME)
INSERT INTO Horario(data) VALUES(@data)
SET @strQuery = 'UPDATE Horario SET '
IF @vlColuna = 0 SET @strQuery = @strQuery + 'Entrada'
ELSE IF @vlColuna = 1 SET @strQuery = @strQuery + 'SaidaAlmoco'
ELSE IF @vlColuna = 2 SET @strQuery = @strQuery + 'VoltaAlmoco'
ELSE IF @vlColuna = 3 SET @strQuery = @strQuery + 'Saida'
ELSE IF @vlColuna = 4 SET @strQuery = @strQuery + 'ExtraInicio'
ELSE IF @vlColuna = 5 SET @strQuery = @strQuery + 'ExtraFim'
SET @strQuery = @strQuery + ' = '''+@vlHora+''' WHERE idData='+CAST(@@identity as NVARCHAR)
EXEC(@strQuery)
END
END
END
Estou fazendo assim na minha classe:
private void atualiza_valor(Object valor,int vlDia,int coluna) throws SQLException{
stmtAtualizaHora = cnx.conn.prepareCall("{call px_Atualiza(?,?,?,?,?)}");
stmtAtualizaHora.setString(0,vlDia+"");
stmtAtualizaHora.setString(1,vlMes+"");
stmtAtualizaHora.setString(2,vlAno+"");
stmtAtualizaHora.setString(3,coluna+"");
stmtAtualizaHora.setString(4,valor.toString());
stmtAtualizaHora.execute();
stmtAtualizaHora.close();
}
Dá o seguinte erro:
Obrigado pela ajuda!!!
FAlow!!