Skip to content

No rows on warnings in SAP ASE #366

@lroal

Description

@lroal

I am not able to get any rows if there are warnings/errors.

[Error: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Duplicate key was ignored.
] {
  sqlstate: 'ZZZZZ',
  code: 3604,
  severity: 0,
  serverName: '',
  procName: '',
  lineNumber: 0
}

The query that were run:

DECLARE @op_message VARCHAR(254)
DECLARE @op_errorlevel_id INT
DECLARE @op_errorcode_id INT

EXECUTE dbo.ssp_dfs_login_dd_bankid_foretak @ip_session_id=null,@ip_dfs_applikasjon_id=5,@ip_bankid_ref='foo', @op_message = @op_message OUT, @op_errorlevel_id = @op_errorlevel_id OUT, @op_errorcode_id = @op_errorcode_id OUT 

SELECT "@op_message" = @op_message, "@op_errorlevel_id" = @op_errorlevel_id, "@op_errorcode_id" = @op_errorcode_id

When running the queries raw with a manager like SqlDbx, I am able to get the rows as well as the error:

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions