https://www.omnidex.com/docs/v54/ 2026-04-29T19:03:10+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:dbprocs:oracle:home&rev=1467153531&do=diff Oracle Omnidex Stored Procedure Interface * Installation * Example Code Oracle Omnidex Routines Routine Description OdxConnectEnv Establishes a connection to an Omnidex Environment OdxDisconnectEnv OdxConnectEnv OdxOpenCursor OdxCloseCursor OdxIsConnected OdxIsOpened OdxParseSql OdxSetVariable OdxSetColumnType OdxExecuteSql OdxGetRow OdxGetColumn OdxGetLastRowCount OdxGetVersion OdxGetErrorMessage OdxGetPrimaryKeys Odx… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:dbprocs:oracle:install&rev=1467153531&do=diff Oracle Stored Procedure Installation code -- Edit the following example(s) to set the location of the Omnidex PL/Sql interface library -- The first example is for Windows. The second/default is for Sun,Linux,Aix and Tru64 UNIX. -- The third example is for HP-UX UNIX. -- -- Windows: create or replace library odx_lib as 'c:\winnt\system32\odxplora.dll'; -- Sun,Linux,Tru64,AIX: create or replace library odx_lib as '$OMNIDEX_LIBS/libodxplora.so'; -- HP-UX UNIX: create or replace library odx_lib … text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:dbprocs:oracle:sample_code&rev=1467153531&do=diff Oracle PL/SQL Omnidex Sample Code set serveroutput on declare instance_num integer; cursor_num integer; child_cursor integer; qual_count integer; ignore integer; customer_num number; company varchar2(42); contact varchar2(26); date_tickler varchar2(6); tickler varchar2(4); initials varchar2(6); action_info varchar2(62); counter number; begin dbms_output.enable(); -- opening a database from PL/SQL using CL datasourc…