SQL Anywhere Mobile - error with end

Author

error with end_upload script

liy

2005-10-31, 1:23 pm

Added the end_upload script in ORACLE 9.2.0.1.0 database with ASA 9.0.1, but
the following errors occurred:

I. 10/31 12:57:13. <1.5> [5]: end_upload <connection>
exec test
I. 10/31 12:57:13. <1.5> [5]: Cached ODBC statement:
exec test
E. 10/31 12:57:13. <1.5> [5]: Error: [-10002] ODBC: [DataDirect][ODBC Oracle
Wire Protocol driver][Oracle]ORA-00900: invalid SQL statement (ODBC State =
42000, Native error code = 900)
I. 10/31 12:57:13. <1.5> [5]: Error Context:
I. 10/31 12:57:13. <1.5> [5]: User Name: 5
I. 10/31 12:57:13. <1.5> [5]: Modified User Name: 5
I. 10/31 12:57:13. <1.5> [5]: Transaction: upload
I. 10/31 12:57:13. <1.5> [5]: Table Name: NULL
I. 10/31 12:57:13. <1.5> [5]: Script Version: ver_1
.. 10/31 12:57:13. <1.5> [5]: Script: exec test
I. 10/31 12:57:13. <1.5> [5]: End of Error Context

Below is how the script was setup

exec ml_add_connection_sc
ript('ver_1', 'end_upload', 'exec test');

CREATE OR REPLACE procedure test
as
begin
delete from sms_tr_log
where sms_userid = 2;
commit;
end;
/

Reg Domaratzki $iAnywhere Solutions$

2005-10-31, 1:23 pm

You should never execute commits or rollbacks inside your synchronization
scripts. I would remove the commit from the "test" stored procedure or you
run the possible risk of data loss during synchronization if a connection is
dropped.

To answer your immediate question, we always suggest that you use the ODBC
standard for calling stored procedures when defining your synchronization
scripts. Does the following work :

exec ml_add_connection_sc
ript('ver_1', 'end_upload', '{call test}');

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"liy" <li_yuping@bls.gov> wrote in message news:43665e12@forums
-1-dub...
> Added the end_upload script in ORACLE 9.2.0.1.0 database with ASA 9.0.1,
but
> the following errors occurred:
>
> I. 10/31 12:57:13. <1.5> [5]: end_upload <connection>
> exec test
> I. 10/31 12:57:13. <1.5> [5]: Cached ODBC statement:
> exec test
> E. 10/31 12:57:13. <1.5> [5]: Error: [-10002] ODBC: [DataDirect][ODBC
Oracle
> Wire Protocol driver][Oracle]ORA-00900: invalid SQL statement (ODBC State
=
> 42000, Native error code = 900)
> I. 10/31 12:57:13. <1.5> [5]: Error Context:
> I. 10/31 12:57:13. <1.5> [5]: User Name: 5
> I. 10/31 12:57:13. <1.5> [5]: Modified User Name: 5
> I. 10/31 12:57:13. <1.5> [5]: Transaction: upload
> I. 10/31 12:57:13. <1.5> [5]: Table Name: NULL
> I. 10/31 12:57:13. <1.5> [5]: Script Version: ver_1
> . 10/31 12:57:13. <1.5> [5]: Script: exec test
> I. 10/31 12:57:13. <1.5> [5]: End of Error Context
>
> Below is how the script was setup
>
> exec ml_add_connection_sc
ript('ver_1', 'end_upload', 'exec test');
>
> CREATE OR REPLACE procedure test
> as
> begin
> delete from sms_tr_log
> where sms_userid = 2;
> commit;
> end;
> /
>
>

liy

2005-10-31, 8:24 pm

It works. Thanks for your help.

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:43666d6b$1@foru
ms-1-dub...
> You should never execute commits or rollbacks inside your synchronization
> scripts. I would remove the commit from the "test" stored procedure or
> you
> run the possible risk of data loss during synchronization if a connection
> is
> dropped.
>
> To answer your immediate question, we always suggest that you use the ODBC
> standard for calling stored procedures when defining your synchronization
> scripts. Does the following work :
>
> exec ml_add_connection_sc
ript('ver_1', 'end_upload', '{call test}');
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "liy" <li_yuping@bls.gov> wrote in message news:43665e12@forums
-1-dub...
> but
> Oracle
> =
>
>

Sponsored Links