473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 11359
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 HP-UX and Pro/5 What I'm trying to do:
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 (Dev-C++ 4.9.8.0 from Source-Forge)? ...
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 <time.h> Unfortunately, my compiler doesn't...
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 of possibly unassigned field 'price' according...
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 the code involved to the following If someone could...
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 gnu are compatible to use with icc. But we would...
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 types This refers to a typedef that I have...
26
by: empriser | last post by:
#define XLOG( ... ) \ do{ \ sprintf( SysBuf, " ", curtime(), __FILE__ , __LINE__ , __FUNCTION__ ); \ sprintf( SysBuf + strlen( SysBuf ), __VA_ARGS__ ); \ xlog( SysBuf ); \ }while(0) I...
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 ls_scale_cnstr_weight_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 compile the program and I get the following errors: ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.