Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PCC-S-02322, found undefined identifier
I have got the same problem
(PCC-S-02322, found undefined identifier)
with function ListRecords ()
from demo-file lobbdemo1.pc
in $ORACLE_HOME/precomp/demo/proc
Something is wrong. What?
Thanks in advance, Alex //######################################################### //------------------- Pro*C++ code : BEGIN ----------------
// File ttt2.pc
#include <stdio.h>
#include <sqlca.h>
#include <oraca.h>
#include <sqlcpr.h>
#include <sqlda.h>
void ListRecords()
{
char *select_sss="SELECT SSS FROM LICENSE_TABLE"; char sss[10];
EXEC SQL PREPARE sss_exec FROM :select_sss; // Line#14
EXEC SQL DECLARE sss_cursor CURSOR FOR sss_exec;
EXEC SQL OPEN sss_cursor;
printf("Available records:\n");
for(;;)
{
EXEC SQL FETCH sss_cursor INTO :sss; // Line#24
if(sqlca.sqlcode == 1403) break; printf("\t%s\n", sss);
}
EXEC SQL CLOSE sss_cursor;
}
int main ()
{
ListRecords (); return 0;
//------------------- Pro*C++ code : END ------------------ //######################################################### //------------------- Compilation Results : BEGIN ---------
code=cpp
sys_include=(/opt/SUNWspro/SC4.2/include,/opt/SUNWspro/SC4.2/include/CC,/usr/include,/opt/SUNWspro/RW/workspaces/SOLARIS26/SUNPRO42/7s)
code=cpp
sys_include=(/opt/SUNWspro/SC4.2/include,/opt/SUNWspro/SC4.2/include/CC,/usr/include,/opt/SUNWspro/RW/workspaces/SOLARIS26/SUNPRO42/7s)
proc code=cpp
sys_include='(/opt/SUNWspro/SC4.2/include,/opt/SUNWspro/SC4.2/include/CC,/usr/include,/opt/SUNWspro/RW/workspaces/SOLARIS26/SUNPRO42/7s)'
iname=ttt2 LINES=YES CPP_SUFFIX=cpp
Pro*C/C++: Release 8.0.5.0.0 - Production on Wed Oct 13 12:6:0 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.
System default option values taken from: /home/u01/app/oracle/product/8.0.5/precomp/admin/pcscfg.cfg
Semantic error at line 14, column 35, file ttt2.pc: EXEC SQL PREPARE sss_exec FROM :select_sss;
.................................1
...........................1
EXEC SQL FETCH sss_cursor INTO :sss;
.....................................1
//------------------- Compilation Results : END ----------- //######################################################### //------------------- System ------------------------------ === Oracle 8.0.5
//--------------------------------------------------------- //#########################################################
![]() |
![]() |