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

From: Richard Woods <rawoods_at_concentric.net>
Date: 1996/08/30
Message-ID: <3227A083.5E9A_at_concentric.net>#1/1


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.
Received on Fri Aug 30 1996 - 00:00:00 CEST

Original text of this message