Share this page

# Example: lrd_open_cursor

In the following example, a cursor is opened after a connection is made with an Oracle server. An SQL statement is executed using the cursor.

    lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "fred", "lion", "hammer", "", 0, 0, 0);

    lrd_open_cursor(&Csr1, Con1, 0);

    . . .

    lrd_stmt(Csr1, "select ename\nfrom emp\nwhere job='CLERK'\n\n", -1, 1, 1, 0);

    lrd_bind_col(Csr1, 1, &D11_ENAME, 0);

    lrd_exec(Csr1, 0, 0, 0, 0);

    lrd_fetch(Csr1, -4, 15, 0, PrintRow16, 0);

    lrd_commit(Con1, 0);

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: