|
Home > Archive > SQL Anywhere Mobile > June 2005 > Stored Procedure Table Scripts
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Stored Procedure Table Scripts
|
|
|
| In the docs...
MobiLink Synchronization User's Guide
Synchronization Techniques
Downloading a result set from a stored procedure call
....it states that there is a difference in the signatures between SQL Server
and Oracle stored procedures when returning a result set. SQL Svr uses 2 in
the example given, but Oracle requires 3. I need to write one .NET assembly
to handle multiple iAnywhere-supported databases and I'm wondering how to
write the download_cursor method in .NET that uses a generic stored
procedure call if the sp signatures may differ between platforms.
Thanks,
Tim
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-10, 9:23 am |
| The call made from MobiLink is the same though, despite the differences in
the number of parameters in the two stored procedure calls. When calling
the stored procedure on either MSS or Oracle, you can use :
{call MyProc( ?, ? ) }
( I may have completely missed your point, but nobody else was
responding... )
--
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 "Platform Preview" and "Time Frame" to ALL
"Tim" <nospam@nospam.com> wrote in message news:42a89445$1@foru
ms-2-dub...
> In the docs...
>
> MobiLink Synchronization User's Guide
> Synchronization Techniques
> Downloading a result set from a stored procedure call
>
> ...it states that there is a difference in the signatures between SQL
Server
> and Oracle stored procedures when returning a result set. SQL Svr uses 2
in
> the example given, but Oracle requires 3. I need to write one .NET
assembly
> to handle multiple iAnywhere-supported databases and I'm wondering how to
> write the download_cursor method in .NET that uses a generic stored
> procedure call if the sp signatures may differ between platforms.
>
> Thanks,
> Tim
>
>
|
|
|
|
|