Re: Help needed in setting up PRO*C enviornment.

user_at_upj.com wrote:
>
> 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.The PRO*C precompiler does not by default check the validity of embedded
SQL statements against the database. It does, however, check the validity of PL/SQL blocks within a PRO*C program by connecting to the database. You'll need to modify proc.mk to specify a userid/password that has at least select access on all the database objects referenced in PL/SQL blocks within the program.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.