Quick Help

Knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.



 Call stored procedure from SQL Database Professional

Problem

I have a problem, with the plugin we have, SQL Database Professional fro Data Loggers. We are trying to run a stored procedure (Microsoft SQL Server 2008 R2) but we are facing some problems, with a simple INSERT works like charm, but I don't know how to run a procedure. What we are running now is:

Insert into ETK_GPSData
(DateStamp,
DataSourceName,
DataSourceFullName,
IDDevice,
Command,
GPSData,
GPSValidData,
GPSLatitude,
GPSLongitude,
IOPortStateData,
MilleMeter,
AlarmData,
ADImputData,
GPSTimeRecord,
GPSSpeed,
GPSHeading,
GPSDateRecord,
GPSLatitudeOrientation,
GPSLongitudeOrientation)
values
(:P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19)


but I wish to run this procedure:

execute etk_gpsdata_spi(:P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19)

but I get error message every time.


Solution


The format of the SQL statement should be:

exec etk_gpsdata_spi :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19;

 
Was this article helpful? yes / no

Article details

Article ID: 46

Category: Data Loggers

Date added: 2011-04-27 05:25:53

Views : 1450

Rating (Votes): Article rated 4.0/5.0 (4)