` Printed Icetips Article

Icetips Article

SQL Related Articles: Returning values from Stored Procedures using OUT
2002-04-11 -- Michael Gould

Newsgroups: TopSpeed.Products.Drivers

Alexander,

Here is the example program from the help file.  This should get you
started.

Michael Gould



Example:

PROGRAM

MAP
 CallProc(STRING)
END

MyFile  FILE,DRIVER('MSSQL')
Record  RECORD
c     LONG
    . .
Ret   LONG
Out   STRING(10)

  CODE

BIND('RetCode', Ret)
BIND('Out', Out)
CallProc('&RetCode = CALL StoredProcTest(''1'',&Out)')
MESSAGE('Return value of StoredProcTest =' & Ret)
MESSAGE('Output parameter of StoredProcTest =' & Out)

CallProc PROCEDURE(Str)
 CODE
MyFile{PROP:SQL} = Str




Note: The above example shows how to return an output parameter.
"Alexander"  wrote in message
news:3cb55d57@news.softvelocity.com...
> Hi All!
>
> Somebody knows as to receive OUT parameter from stored procedure
> (SYBASE SQL Anywhere 5.5.04). Would be grateful for an example.
>
> Best regards,
> Alexander
>
>

Printed April 30, 2024, 2:19 am
This article has been viewed/printed 35113 times.
Google search has resulted in 55 hits on this article since January 25, 2004.