Sybase stored procedures returning more then one values

[vrs1008]

Hi,

I have to use sybase stored procedures in my map which will accept 2 values & return 2 values. I am using the following commands to access the stored procedure (Trace file gives the error without returned variable) but I really don't know how & where to retrive the returned paramaters??

~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DBQUERY ("exec ODS_SP_DATE 1 ," + "Vibhav",
"-DBTYPE SYBASE -SOURCE sybase1\\Dev -USER vrshah -PASSWORD abcde -t" )
~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Can you please guide me for the same??


Regards,
Vibhav1008

 

[vrs1008]

In one of the Posts BocaBurger gave following command to get the value back from the oracle stored procedures.

"Call?=procedurename (param1, param2, ?)"

What about sybase as sybase is using exec instead of call???

Regards,
Vibhav1008

 

[vrs1008]

Hi,

I got the answer & it is...for returning 4 values

=DBLOOKUP ("call ODS_SP_DATE2 ( 1," + "Vibhav" + ",?,?,?,?/ )",
"-DBTYPE SYBASE -SOURCE sybase\\dev -USER abc -PASSWORD abc -t" )

Thanks...


Regards,
Vibhav1008