Hi,

I am trying to migrate a report generator written in Pro C to Java.
But when i'm precompiling the Pro*C code using the Oracle Pro*C tool
it spews out the following errors.

int CreWhereClause(char *szRunDate,...)
{
EXEC SQL SELECT to_char(to_date(:yesterday, 'dd-mon-yyyy'),
'dd-mon-yyyy') INTO :szRunDate from dual;


PCC-S-02322, found undefined identifier
Semantic error at line 649, column 94, file C:\temp.pc:
EXEC SQL SELECT to_char(to_date(:yesterday, 'dd-mon-yyyy'),
'dd-mon-
yyyy') INTO :szRunDate from dual;




I have no clue as to how to get rid of the above errors.

Any help appreciated...


Thanks

Aakash wrote:
> Hi,
>
> I am trying to migrate a report generator written in Pro C to Java.
> But when i'm precompiling the Pro*C code using the Oracle Pro*C tool
> it spews out the following errors.
>
> int CreWhereClause(char *szRunDate,...)
> {
> EXEC SQL SELECT to_char(to_date(:yesterday, 'dd-mon-yyyy'),
> 'dd-mon-yyyy') INTO :szRunDate from dual;
>
>
> PCC-S-02322, found undefined identifier
> Semantic error at line 649, column 94, file C:\temp.pc:
> EXEC SQL SELECT to_char(to_date(:yesterday, 'dd-mon-yyyy'),
> 'dd-mon-
> yyyy') INTO :szRunDate from dual;
>
>
>
>
> I have no clue as to how to get rid of the above errors.
>
> Any help appreciated...
>
>
> Thanks
>

Could it be that the input lines are too long?

SO did you check the error? Are all the variables declared in C
properly?

What data types? Did you DECLARE them to the precompiler?

Ed

Check the declaration of char/varchar host variable ":szRunDate"

Aakash wrote:
> Hi,
>
> I am trying to migrate a report generator written in Pro C to Java.
> But when i'm precompiling the Pro*C code using the Oracle Pro*C tool
> it spews out the following errors.
>