output.c

来自「ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.」· C语言 代码 · 共 38 行

#include "ocilib.h"

int main()
{
    OCI_Connection *cn;
    OCI_Statement  *st;
    const dtext *p;

    if (!OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT))
        return EXIT_FAILURE;

    cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);
    st = OCI_CreateStatement(cn);

    /* pl/sql call */

    /* server output */

    OCI_ServerEnableOutput(cn, 32000, 5, 255);

    OCI_ExecuteStmt(st, "begin "
                        "   dbms_output.put_line('First  line'); "
                        "   dbms_output.put_line('Second line'); "
                        "   dbms_output.put_line('Third  line'); "
                        "end;"
                   );
 
    while (p = OCI_ServerGetOutput(cn)) 
    {
        print_dstr(p);
        print_text("\n");
    }
 
    OCI_Cleanup();

    return EXIT_SUCCESS;
}