Help needed in setting up PRO*C enviornment.

From: <user_at_upj.com>
Date: 1996/08/30
Message-ID: <507god$8jc_at_inet-1.pharmacia.se>#1/1

We have recently installed ORACLE 7.3.2 Database & PRO*C 2.2 precompiler on HP9000 running HP-UNIX operating system. I am able to use SQLPLUS to access the database and do query on tables. In my PRO * C program I have coded SQL statement as follows,

EXEC SQL EXECUTE
BEGIN

	SELECT EMP_NAME INTO :l_emp_name
	FROM EMP
	WHERE EMP_NO = :l_emp_no ;

END;
END-EXEC; While Precompiling this program I get an error message telling "Object EMP" does not exist. while this table exist when I check using sqlplus.I don't get any error message for other statements like CONNECT, INCLUDE SQLCA etc... Does Precompiler reads Database for table information ? Please tell me if anybody has information regarding what is going wrong. Also what are the parameters to take care after installing PRO*C ?

Shailesh. Received on Fri Aug 30 1996 - 00:00:00 CEST