Documentation dev:dbprocs:sqlserver
https://www.omnidex.com/docs/v54/
2026-06-17T04:20:10+0000Documentation
https://www.omnidex.com/docs/v54/
https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.icotext/html2016-06-28T22:38:51+0000Anonymous (anonymous@undisclosed.example.com)dev:dbprocs:sqlserver:home
https://www.omnidex.com/docs/v54/doku.php?id=dev:dbprocs:sqlserver:home&rev=1467153531&do=diff
SQL Server Stored Procedure Interface
The SQL Server Stored Procedure Interface comes in the form of Extended Stored Procedures.
* SQL Server Stored Procedure Example
Installation
With the SQL Server Stored Procedure Interface dll, odxplssv.dll, in place in the OMNIDEX_HOME/bin directory, the following SQL script can be run in SQL Query Analyzer to install the extended stored procedures in the Master database.text/html2016-06-28T22:38:51+0000Anonymous (anonymous@undisclosed.example.com)dev:dbprocs:sqlserver:sample_code
https://www.omnidex.com/docs/v54/doku.php?id=dev:dbprocs:sqlserver:sample_code&rev=1467153531&do=diff
SQL Server Stored Procedure Example
begin
declare @status int
declare @instance_num int
declare @cursor_num int
declare @child_cursor int
declare @qual_count int
declare @customer_num int
declare @company varchar(42)
declare @contact varchar(26)
declare @date_tickler datetime
declare @tickler varchar(4)
declare @initials varchar(6)
declare @action_info varchar(62)
declare @message varchar(256)
declare @counter int
-- openin…