Executing MSSQL function

[Tomin]

Hi,

I have a problem with executing MSSQL function.
I was trying MSStoredProc component but in a runtime it is showing me error of the execution:
"Line1: Invalid procedure number(0). Mustbe between 1 and 32767'

Have someone succeded to call functions with SDAC?

Tomin

[Antaeus]

Please provide some more information about the the error:
- the command text of your TMSSQL component;
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

[Tomin]

Please provide some more information about the the error:
- the command text of your TMSSQL component;
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

1.
I'm tying to use TMSStoredProc for calling a function. The SQL command text is:
{:RETURN_VALUE = CALL fn_Supervision_NewNo;0(:ProjectID)}

where
:ProjectID is a string
:RETURN_VALUE defined as a Result in the body of MSSQL function is also string value

2.
My current SDAC version is: 4.35.0.17

3.
I'm using Delphi 2007 with installed SP3

4. Sql Server info is as follow
Microsoft SQL Server: 09.00.3054
Microsoft SQL Native Client: 9.00.3042.00

Thanks for your help in advance

Tomin

[Antaeus]

You should remove the semicolon and zero symbols from the command to make it work:

Code: Select all

{:RETURN_VALUE = CALL fn_Supervision_NewNo (:ProjectID)}