Re: Oracle Error - Please Help

I precompiled this code below (after adding "char email_addr[25]") in 7.1, 7.3, 8.0, and 8.1. I cannot reproduce.

Perhaps you need to post the example that doesn't precompile -- also platform, version numbers, etc, etc would help as well.

A cut and past of the precompile command and errors messages would be very helpful too.

A copy of this was sent to NeedaHoliday (if that email address didn't require changing) On Tue, 25 May 1999 19:11:33 GMT, you wrote:

>I keep getting a compilation error with the following code. This code
>resides in two programs. One program compiles and the other doesn't.
>Makes no sense. Can someone help.
>
>The compilation message is "end_of_email_list" label not found.
>
>void error_msg()
>{
> char lc_err_string[151];
>
>
> EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE error poll
>error_msg() address--\n");
> EXEC SQL DECLARE cemail_cur CURSOR FOR
> SELECT EML_USR_ID
> FROM EMPLOYEE
> WHERE UPPER(USR_LAN_ID) = 'CIMSERR'
> AND EXP_DT IS NULL;
>
> EXEC SQL OPEN cemail_cur; /* open cinv_cur cursor */
> while (TRUE) /* while loop */
> {
> strcpy(email_addr, " ");
> EXEC SQL WHENEVER NOT FOUND GOTO end_of_email_list;
> EXEC SQL FETCH cemail_cur INTO
> :email_addr;
>
> if(email_addr != NULL)
> strcpy(lc_err_string, "");
> strcpy(lc_err_string, "echo \"Please verify ERRTBL \"");
> strcat(lc_err_string, MAIL);
> strcat(lc_err_string, "\" CIMS error has ocurred \"");
> strncat(lc_err_string, COLSPACE, 1);
> strcat(lc_err_string, email_addr);
> system(lc_err_string);
> }
> end_of_email_list:
> EXEC SQL CLOSE cemail_cur;
>
>
>} /* error_msg() */

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 26 1999 - 07:00:14 CDT