472,331 Members | 1,753 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,331 software developers and data experts.

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 10907
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

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

Similar topics

1
by: Dominic | last post by:
Hi, I am TOTALLY new to all this stuff and really hope to find help here. I have to come up with a solution for one of my client. They use...
5
by: Jan Kassens | last post by:
Hi NG I've written this little test-program. Why does it open a console/cmd shell and how to prevent this? Is it a problem with my compiler...
7
by: Ebay boy | last post by:
I have recently bought a compiler and I have this sample code that includes the following: #include <stdlib.h> #include <string.h> #include...
5
by: Fahad Ashfaque | last post by:
qaHi, I am trying to assign value to a member of object of a struct, the object is treated under foreach. I got the error : error CS0170: Use...
3
by: Binary | last post by:
VC++ .NET 2003: Access violation with /O2 compiler switch; no AV with /O Hi I'm in the process of narrowing down a problem, and I have reduced...
1
by: Vijay Jain | last post by:
Hi All, We have a requirement to use icc compiler instead of existing gnu compiler. Though the icc compiler states that libraries compiled with...
4
by: tfawcet | last post by:
I am having a problem with the Visual C++ compiler with the following error c:\rgb.h(7) : error C2371: 'pix_t' : redefinition; different basic...
26
by: empriser | last post by:
#define XLOG( ... ) \ do{ \ sprintf( SysBuf, " ", curtime(), __FILE__ , __LINE__ , __FUNCTION__ ); \ sprintf( SysBuf + strlen( SysBuf ),...
1
by: rajesh.chidambaram | last post by:
int load_convers_data() { char *function = "load_convers_data"; long i; int j; int li_return; char ls_scale_cnstr_dimension_uom = ""; char...
6
by: Kid Programmer | last post by:
Hello guys. I have a question. What's wrong with my compiler. In a simple number averaging program in a GUI window have way into the project I...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.