#include <sqlca.h>
#include <stdio.h>


EXEC SQL WHENEVER SQLERROR CONTINUE;    /* slouzi k osetreni chyb, takze chyba v tomto osetreni by skoncila zacyklenim */
void sql_error(const char * info ){     /* misto void bychom mohli dat const char * a mohli bychom pri volani specifikovat, kde v kodu doslo k chybeOA  */
        char err_mess[513];
        size_t err_mess_len = sizeof(err_mess);
        size_t err_len;
        sqlglm ( err_mess, &err_mess_len, & err_len );
        err_mess [ err_len ] = '\0';
        printf("Chyba Oracle ( %s ): %s\n", info, err_mess );
        EXEC SQL ROLLBACK WORK RELEASE;         /* doslo k chybe, takze musime rollbackovat pro udrzeni konsistence dat */
        exit(1);
        };

EXEC SQL BEGIN DECLARE SECTION;
        char table_name [50][31];
        char comment [50][101];
        short comment_ind[50];                  /* deklarujeme si indikator pro pole comment pro osetreni NULL hodnot */
EXEC SQL END DECLARE SECTION;


EXEC SQL DECLARE cursor CURSOR FOR
        SELECT table_name, comments FROM DICT
        WHERE table_name LIKE 'USER%'
        ORDER BY table_name;
        /*  klauzule ORDER BY musi byt za WHERE */


int main( void ){
        char * login = "dbadmin/db6semora@semora";
        unsigned int i;
        EXEC SQL WHENEVER SQLERROR DO sql_error("Pripojeni k databazi");                /* pro pripad, ze se nam nepodari pripojit do databaze */
        EXEC SQL CONNECT :login;
        EXEC SQL OPEN cursor;

      unsigned int pocet_radku_k_nacteni = 50;
        unsigned int pocet_nactenych_radku = 0;
        unsigned int pocet_radku_stary = 0;

        EXEC SQL WHENEVER SQLERROR DO sql_error("Chyba pri cteni");
/*      EXEC SQL WHENEVER SQLERROR CONTINUE;*/
        /*EXEC SQL WHENEVER NOT FOUND DO sql_error( "NOT FOUND na hostitelskych polich " );*/
                /* tato direktiva whenever je zbytecna, nebot pripad docteni dat osetrime pomoci pocet_nactenych_radku  */
        while ( 1 ){
                EXEC SQL FETCH cursor INTO :table_name, :comment:comment_ind;  /* nacteme radky */
                pocet_nactenych_radku = sqlca.sqlerrd[2] - pocet_radku_stary;  /* sqlca.sqlerrd[2] obsahuje celkovy pocet doted nafetchovanych radku */
                pocet_radku_stary = sqlca.sqlerrd [2] ;

                for ( i = 0 ; i < pocet_nactenych_radku; i++ ){
                        if ( comment_ind [i] == 0 )
                                printf("%s\t%s\n", table_name [i], comment [i] );
                        else
                                printf("%s\t%s\n", table_name [i], "NULL");
                        };      /* for pres nactene radky */
        if (  pocet_nactenych_radku  < pocet_radku_k_nacteni )  /* nutne osetrit tady!! */
                break;                  /* docetli jsme vsechny mozne radky odpovidajici nasemu dotazu, vyskocime z while */

        };      /* while ( 1 )  */
        EXEC SQL CLOSE cursor;
        EXEC SQL COMMIT WORK RELEASE;
        return 0;
        };