PowerBuilder · Database exception
What does SQLDBCode 999 (Procedure Has No Return Value) mean in PowerBuilder?
SQLCA.SQLDBCode returns 999 with the message 'The Procedure Has No Return Value' when PowerBuilder's OLE DB provider (e.g. SQLNCLI11) calls a SQL Server stored procedure through embedded SQL and the procedure invocation isn't recognized as returning a result the driver can bind to, even though the same procedure call worked under an older PowerBuilder/driver combination. This is a PowerBuilder OLE DB interface-generated code rather than one produced by SQL Server itself.
SQLCA.SQLDBCode returns 999 with the message 'The Procedure Has No Return Value' when PowerBuilder's OLE DB provider (e.g. SQLNCLI11) calls a SQL Server stored procedure through embedded SQL and the procedure invocation isn't recognized as returning a result the driver can bind to, even though the same procedure call worked under an older PowerBuilder/driver combination. This is a PowerBuilder OLE DB interface-generated code rather than one produced by SQL Server itself.
Confirm the stored procedure call syntax and DBParm settings (such as PB ODBC/OLE DB stored-procedure invocation options) match what the current PowerBuilder version's driver expects, since behavior here has changed across PowerBuilder/OLE DB provider versions. When migrating forward from an older PowerBuilder release, retest every stored-procedure-backed DataWindow rather than assuming unchanged SQL will keep working.