| Aaron Reicher 2005-03-30, 9:42 am |
| Thanks to you all for your help. This turned out to be a problem with the
way the scripts were being called.
The new driver seems to do less translation than the old; and in the always
consistent world of Oracle, you can't use the Call syntax here. So unless
the handle_error script is forced to use standard ODBC syntax, it doesn't
get the return value.
So instead of:
call ml_add_connection_sc
ript('version1','han
dle_error','Call
P_RM_HANDLEERROR( ?, ?, ?, ?, ?)' );
We needed to use:
call ml_add_connection_sc
ript('version1','han
dle_error','{Call
P_RM_HANDLEERROR( ?, ?, ?, ?, ?)}' );
Aaron
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:ns8r11trsf68ugs
ivqaigfoq78alm8grro@
4ax.com...
> Wow, I completely *missed* this in your original posting...
>
>
> Graham has the answer for you :)
>
> Breck
>
> On 23 Feb 2005 09:21:28 -0800, "Aaron Reicher"
> < no_reply_by_email@di
ginsp.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
|