topic Re: compiling Pro*C code without tables in Operating System - HP-UX

compiling Pro*C code without tables

Manish Srivastava — Fri, 30 Jul 2004 10:41:28 GMT

Hi All,

I am involved in a porting POC in which I have the Pro*C code but do not have the databse definitions as yet. I want to compile the Pro*C programs without the database definitions.Is it possible to do this? if yes then how?

I am a first time Oracle user so a detailed reply will really help.

Regards,
Manish.

Re: compiling Pro*C code without tables

Hemanth Gurunath Basrur — Sun, 01 Aug 2004 22:18:34 GMT

Hi Manish,

Check if the foll. link helps:

http://tahiti.oracle.com/pls/tahiti/tahiti.show_mindex?letter=c

There is lot of information on compilation here.

HTH.

Regards,
Hemanth

Re: compiling Pro*C code without tables

R. Allan Hicks — Mon, 02 Aug 2004 08:42:59 GMT

SQLCHECK=NONE will cause it to ignore most of the sql. It will not allow you to create a usable program, just let you know if the non-sql is good.

Re: compiling Pro*C code without tables

Manish Srivastava — Mon, 02 Aug 2004 08:52:11 GMT

Hi Allan,

This helps me only in very few files. Most of the files no not show any difference with and without the SQHCHECK=NONE in the makefile.

manish

Re: compiling Pro*C code without tables

Manish Srivastava — Mon, 02 Aug 2004 08:54:47 GMT

Hi,

Will it be a good idea to mask off all the SQL's and then compile the files. I just want to check that there is no problemin the C code part of the .pc files.

manish

Re: compiling Pro*C code without tables

R. Allan Hicks — Fri, 27 Aug 2004 09:59:35 GMT

Commenting out all of the EXEC SQL's should help. I'd think you might run into some problems with the host values.

One question I should have asked on the front end......

Why don't you want to compile against the tables? Is it because you don't want to have the space associated with the tables?

You can get a PC version of the server from OTN.
Create a database link to your production database.
Create a table as create foo as select * from foo@data_link where 1=2;
The above creates the table with no data. The pro*c code should be happy because it is only validating the table structure and you get to find any SQL problems.

Hope this helps

Re: compiling Pro*C code without tables

Jean-Luc Oudart — Fri, 27 Aug 2004 10:43:23 GMT

Hi Manish,

If your code contains PL/SQL blocks you will require SQLCHECK=SEMANTIC and therefore a connection to a database with table description is then required.

Regards,
Jean-Luc