#include #include 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; };