Stored Procedure Exception: La instrucción no devolvio un conjunto de resultados

[leonardomartinez]

Hi, i'm trying to call a stored procedure from JasperSoft Studio 5.6.2, The stored procedure is allocated in a bd SQL SERVER, i'm using sqljdbc4 connector

The parameters of sp are: @emp_id tinyint, @fecha1 char(8),  @fecha2 char(8), @cliente int,  @sitio varchar(200), @usu_id int

and i'm calling the sp like this:

execute rep_dr_ventas_cli_sec_nx 1,'20140801','20140802',0,'0',1

i get this Exception:

La instrucción no devolvió un conjunto de resultados

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Blank_A4_Landscape

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)

at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:67)

at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:75)

at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:359)

at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:54)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: La instrucción no devolvió un conjunto de resultados.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:408)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)

... 5 more

 

 

..Any idea?, Thanks!

[fernando2k3]

it's the full log? already probastes the PL manually? of returns data?

[leonardomartinez]

yes, i tested with sql and plsql and the result is the same

[freddyvalle]

Buenas tardes mi nombre es Freddy Valle y tengo el mismo problema por favor si nos pueden ayudar para dar solución a este inconveniente?