Subject | general problem? |
---|---|
Author | Olaf Kluge |
Post date | 2011-05-14T20:28:48Z |
Hello,
I cannot understand the following:
One stored procedure tests a inputstring of numeric content. If not numeric,
the numeric return value is 0 and the status too. There is in this case
another procedure called, which inserts an error message in an error table.
If numeric, the status is 1, no error entry will set.
If I call this verification procedure in my sql-editor, in case of failure
will create a record in error table and I get 0 and 0.
Now, if I exactly call this procedure in another procedure like " select
output_param, status from GetNumericFromString('1111A') into :INTVALUE,
:STATUSVALUE;, the called procedure writes no error entry! Why not? It is
the same called check-stored-procedures.
Thank you for your help.
Nice weekend
Olaf
[Non-text portions of this message have been removed]
I cannot understand the following:
One stored procedure tests a inputstring of numeric content. If not numeric,
the numeric return value is 0 and the status too. There is in this case
another procedure called, which inserts an error message in an error table.
If numeric, the status is 1, no error entry will set.
If I call this verification procedure in my sql-editor, in case of failure
will create a record in error table and I get 0 and 0.
Now, if I exactly call this procedure in another procedure like " select
output_param, status from GetNumericFromString('1111A') into :INTVALUE,
:STATUSVALUE;, the called procedure writes no error entry! Why not? It is
the same called check-stored-procedures.
Thank you for your help.
Nice weekend
Olaf
[Non-text portions of this message have been removed]