search

mridoni / gixsql

GixSQL is an ESQL preprocessor and a series of runtime libraries to enable GnuCOBOL to access PostgreSQL, ODBC, MySQL, Oracle and SQLite databases.
GNU General Public License v3.0
16 stars 8 forks source link

libgixsql-pg: inspect into naming cursors / parameters #123

Open GitMensch opened 2 years ago

GitMensch commented 2 years ago

When there is an error in "GIXSQLExecSelectIntoOne" then libpg's error may show something "helpful" like;

ERROR: invalid input syntax for type bytea CONTEXT: unnamed portal parameter $1 = '...'

It would be much more useful if it could be named as in COBOL; in any case this may also mean a performance degradation (I don't know). To provide that we'd likely need a changed ABI with GIXSQLSetSQLParams and GIXSQLSetResultParams taking additionally the name as new parameter.