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 : - ++: Release 9.2.0.1.0 - Production on Tue Mar 1 17:20:48 2011
-
-
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
-
-
System default option values taken from: C:\oracle\ora92\precomp\admin\pcscfg.cfg
-
-
Semantic error at line 567, column 21, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
-
EXEC SQL CONNECT :userName;
-
....................1
-
PCC-S-02322, found undefined identifier
-
Semantic error at line 693, column 41, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
-
WHERE trackouttime BETWEEN :startDate AND :endDate
-
........................................1
-
PCC-S-02322, found undefined identifier
-
Semantic error at line 693, column 56, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
-
WHERE trackouttime BETWEEN :startDate AND :endDate
-
.......................................................1
-
PCC-S-02322, found undefined identifier
-
Semantic error at line 723, column 35, file C:\oracle\ora92\precomp\WaferSleuthV2\ExtractHDBDataForWaferSleuth.pc:
-
EXEC SQL FETCH wsToCursor INTO :wipStep_SK, :toTime;
-
..................................1
-
PCC-S-02322, found undefined identifier
Kindly help me out how i can avoid this error.
4 11359
undefined identifier in error message suggests you have mis-spelled any of the objects in oracle. (table or column name)
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?
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
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,
Sign in to post your reply or Sign up for a free account.
Similar topics
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:
|
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)?
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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:
...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |