Re^3: want to skip displaying of "DBD::Oracle::st execute failed:" error messages showing full query

Maybe you want to also set RaiseError to zero. But I really recommend first reading and understanding the documentation.

Comment on Re^3: want to skip displaying of "DBD::Oracle::st execute failed:" error messages showing full query Download Code

Replies are listed 'Best First'.
Re^4: want to skip displaying of "DBD::Oracle::st execute failed:" error messages showing full query by boftx (Deacon) on Apr 07, 2015 at 17:39 UTC
From DBI: ShowErrorStatement Type: boolean, inherited The ShowErrorStatement attribute can be used to cause the relevant Statement text to be appended to the error messages generated by the RaiseError, PrintError, and PrintWarn attributes. Only applies to errors on statement handles plus the prepare(), do(), and the various select() database handle methods. (The exact format of the appended text is subject to change.) If $h->{ParamValues} returns a hash reference of parameter (placeholder) values then those are formatted and appended to the end of the Statement text in the error message. So instead of `RaiseError` and/or `PrintError` you need to work with `ShowErrorStatement`. That might remove the need to use the `eval` approach below if that is not appealing. You must always remember that the primary goal is to drain the swamp* even when you are hip-deep in alligators.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^4: want to skip displaying of "DBD::Oracle::st execute failed:" error messages showing full query
by boftx (Deacon) on Apr 07, 2015 at 17:39 UTC

From DBI:

ShowErrorStatement Type: boolean, inherited The ShowErrorStatement attribute can be used to cause the relevant Statement text to be appended to the error messages generated by the RaiseError, PrintError, and PrintWarn attributes. Only applies to errors on statement handles plus the prepare(), do(), and the various select*() database handle methods. (The exact format of the appended text is subject to change.) If $h->{ParamValues} returns a hash reference of parameter (placeholder) values then those are formatted and appended to the end of the Statement text in the error message.

RaiseError

PrintError

ShowErrorStatement

eval

You must always remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.

[reply]
[d/l]
[select]