Stored proc and output params

Oleg Kovalevsky

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Stored proc and output params

Hi, all

Somebody can help me, i want testing output parameters from sp on NULL.
SP.ParamByName('bla bla bla').IsNull work only with input parameters.
And what about output?
Enviroment: Delphi C/S 4, SQL Anywhere 5.504, NT4.0

Best wishes,
Oleg

----------------------------------------------------
Oleg Kovalevsky
Moscow, Russia
e-mail: ol...@aha.ru
phone: +7 (095) 203-6451
fax: +7 (095) 290-1252

Team

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored proc and output params

Perhaps it would be easier to test for null inside the SP and return some
non-null result that would inform you of the result of the test.

Juan

Quote

Oleg Kovalevsky wrote in message <6sleb1$h...@forums.borland.com>...
>Hi, all

>Somebody can help me, i want testing output parameters from sp on NULL.
>SP.ParamByName('bla bla bla').IsNull work only with input parameters.
>And what about output?
>Enviroment: Delphi C/S 4, SQL Anywhere 5.504, NT4.0

>Best wishes,
>Oleg

>----------------------------------------------------
>Oleg Kovalevsky
>Moscow, Russia
>e-mail: ol...@aha.ru
>phone: +7 (095) 203-6451
>fax: +7 (095) 290-1252

Oleg Kovalevsk

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored proc and output params

Thanks, Juan

I use this method with integer numbers, but it is not so convenient with
TDateTime and strings.

Oleg

----------------------------------------------------
Oleg Kovalevsky
Moscow, Russia
e-mail: ol...@aha.ru
phone: +7 (095) 203-6451
fax: +7 (095) 290-1252

Quote

Juan Jimenez (TeamB) wrote in message <6snf66$jh...@forums.borland.com>...
>Perhaps it would be easier to test for null inside the SP and return some
>non-null result that would inform you of the result of the test.

>Juan

Other Threads

1. Stored Proc. Params

2. Populating Params in a stored proc object

3. Oracle stored proc wit many params

4. *** Using dataset returnet by a stored proc inside another stored proc ***

5. OUTPUT Params from Stored Procedures HELP MS SQL Server

6. Additional Information for Posting on No Output Params on Stored Procedure

7. Problem with ADO and Output Params of Stored Procedures

8. Problem with Output Params in MS SQL 7 Stored Procs

9. Oracle - Stored Procedure - Output Params - Delphi

10. Output params not being set in stored procedure