469,138 Members | 1,384 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

Having problem with PRO* compiler

kirubagari
158 100+
Dear expert,
Kindly help me on the pro* c compiler .

I'm new to pro* compiler.I have written the code in pro*c and name it as .pc file. When i compile it to make .c file in pro c compiler in oracle,i'm getting some error message ..The error as below :
Expand|Select|Wrap|Line Numbers
  1. ++: Release 9.2.0.1.0 - Production on Tue Mar 1 17:20:48 2011
  2.  
  3. Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  4.  
  5. System default option values taken from: C:\oracle\ora92\precomp\admin\pcscfg.cfg
  6.  
  7. Semantic error at line 567, column 21, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
  8.   EXEC SQL CONNECT :userName; 
  9. ....................1
  10. PCC-S-02322, found undefined identifier
  11. Semantic error at line 693, column 41, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
  12.                    WHERE trackouttime BETWEEN :startDate AND :endDate
  13. ........................................1
  14. PCC-S-02322, found undefined identifier
  15. Semantic error at line 693, column 56, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
  16.                    WHERE trackouttime BETWEEN :startDate AND :endDate
  17. .......................................................1
  18. PCC-S-02322, found undefined identifier
  19. Semantic error at line 723, column 35, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
  20.                 EXEC SQL FETCH wsToCursor INTO :wipStep_SK, :toTime;
  21. ..................................1
  22. PCC-S-02322, found undefined identifier
Kindly help me out how i can avoid this error.
Mar 1 '11 #1
4 10050
debasisdas
8,127 Expert 4TB
undefined identifier in error message suggests you have mis-spelled any of the objects in oracle. (table or column name)
Mar 3 '11 #2
kirubagari
158 100+
I already declare and having the same issue.I have concern here .Compiling the file in UNIX and window environment will be different?Whenever i compile it it putty application ,there is no error and able build the file..When i execute the command to extract data,there is no result?How to put error tracing message in pro*c so that we can able to find where the error is occuring ? or put the printf statemant to see the result one by one.Kindly help?
Mar 4 '11 #3
kirubagari
158 100+
Thanks.

I'm able to compile the file but now there is 1 error still remaining.The error as below.

PCC-F-02081, CMD-LINE: Unterminated option value list or value list was truncated.

I have some question here on how the code is work.

Step1
We write the code in pro*c language.

Step2
Compile the .pc file in pro*c compiler and we will get .c file.

Step3
Run the .exe file in unix environment to get the result

My problem is i would like to debug the code and insert some error trapping message.The code was develop by previous developer.How i can debug the .pc file so that i can see what is happening in behind?should i create log file and etc.

Kindly advice
Mar 7 '11 #4
ziti
1
Hi,
Sys_include is one of the options of the proc so the length of this must be small. Therefore, we must put just the necessary elements for example:
sys_include=($ORACLE_HOME/sdk/include,/usr/include,/usr/lib/gcc/i486-linux-gnu/4.4.3/include) in the file /usr/lib/oracle/11.2/client/precomp/admin/pcscfg.cfg
Regards,
Jul 12 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Dominic | last post: by
5 posts views Thread by Jan Kassens | last post: by
7 posts views Thread by Ebay boy | last post: by
5 posts views Thread by Fahad Ashfaque | last post: by
1 post views Thread by Vijay Jain | last post: by
4 posts views Thread by tfawcet | last post: by
26 posts views Thread by empriser | last post: by
1 post views Thread by rajesh.chidambaram | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.