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