VISOCO Software  Home | Products | Services | Download | Order | Support | Forum | Resources | Search | About
  RSS feedRSS Feed  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  RegisterRegister   ProfileProfile    Log inLog in 
Output parameters

 
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE
Author Message
Andrew
Guest
PostPosted: Wed Aug 21, 2002 11:58 am    Post subject: Output parameters Reply with quote
Hi, I have next trouble.
1) I can't get output parameters when I execute stored procedure because I cacth exception with message "DBX Error: Invalid parameter".
2) I can't set output parameter type of String as Null to stored procedure. I have access violation in driver dll.
Any idea?
Back to top
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Sun Aug 25, 2002 6:57 pm    Post subject: Reply with quote
Hello.

>> 1) I can't get output parameters when I execute stored procedure because I cacth exception with message "DBX Error: Invalid parameter".
This error occurs if you try to get value of a parameter that isn't "OUT".
Can you send us a sample source and stored proc declaration ?

>> 2) I can't set output parameter type of String as Null to stored procedure. I have access violation in driver dll.
Yes. It is a known bug. Next build will not support it. Wink
Back to top
View user's profile Send private message Send e-mail Visit poster's website
PolarBear
Guest
PostPosted: Tue Sep 03, 2002 11:30 am    Post subject: Output parameters bug example Reply with quote
VISOCO support wrote:
...
>> 1) I can't get output parameters when I execute stored procedure because I cacth exception with message "DBX Error: Invalid parameter".
This error occurs if you try to get value of a parameter that isn't "OUT".
Can you send us a sample source and stored proc declaration ?
...


Try to execute this:

params:= TParams.Create(nil);
try
params.CreateParam(ftFMTBcd, '', ptOutput);
SQLConnection1.Execute(
'exec pTest @OutValue= ? output', params);
finally
params.Free();
end;


Stored procedure script is:

CREATE PROCEDURE dbo.pTest @OutValue numeric(15) output
AS
BEGIN
select @OutValue= 1
END
Back to top
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Fri Oct 11, 2002 12:31 am    Post subject: Reply with quote
Use TSQLStoredProc instead
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE All times are GMT + 2 Hours
Page 1 of 1

 


©VISOCO Software. phpBB by phpBB Group