Re: Oracle Error - Please Help

A copy of this was sent to NeedaHoliday (if that email address didn't require changing) On Wed, 26 May 1999 13:23:35 GMT, you wrote:

>The "char email_addr[25]" did exist in the code. I am running on a
>solaris machine using Unix. The version is oracle 7.3.4.
>
>I also added logic to verify if the label did exist by adding an "C"
>IF statement in the logic. The label was found. I have narrowed it
>down to the embedded SQL code. For some reason, the WHENEVER clause
>is not correct.
>
>Is there another way to handle this scenerio. I just want to catch
>the end of file or no records found logic. I am having difficulty
>understanding why the logic compiles in one program and not the other.
>
>
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>System default option values taken from:
>/d2/oracle/7.3.4/precomp/admin/pcscfg.h
>
>cc -xO2 -Xa -xstrconst -xcg92 -xF -mr -K PIC -DSLXMX_ENABLE
>-DSLTS_ENABLE -D_R
>EENTRANT -I. -I/d2/oracle/7.3.4/precomp/public -c poll_invoice.c
>"poll_invoice.c", line 766: undefined label: end_of_email_list
>cc: acomp failed for poll_invoice.c
>*** Error code 2
>make: Fatal error: Command failed for target `poll_invoice.o'
>Wed May 26 09:19:25 EDT 1999
>

Lets see the .pc file. This is a cc error (not even related to pro*c whatsoever).

if you "grep end_of_email_list poll_invoice.c" do you see and 'hits' besides the gotos?

feel free to email me the .pc file that causes the error so I can look at it.

>____________________________________________________-
>
>The compile command:
>
>make -f $ORACLE_HOME/precomp/demo/proc/proc.mk build EXE=poll_invoice
>OBJS=poll_invoice.o \
>PROCFLAGS="userid=$1/$2 sqlcheck=semantics"
>
>
>I AM TOTALLY STUMPED.
>
>
>
>
>On Wed, 26 May 1999 12:00:14 GMT, tkyte_at_us.oracle.com (Thomas Kyte)
>wrote:
>
>>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

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 - 10:01:24 CDT