Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: c precompiler
Fuzhen Yang wrote:
>
> Hi, I got a serious problem with the following program which is used to
> create a table (DEPT_LOCATION) and insert two lines of values. I compiled the
> program using oracle C Precompiler and run it successfully. But when I went to
> my oracle system, I used statement "select Table_Name from USER_TABLES", the
> table I created using Pre C program didn't show up, which means the table
> "DEPT_LOCATION" was not created. I don't know does the table created using pre
> C program only exists during runtime of the program or should exist forever?
> I need idea for that.
> Good luck to everybody!!!
>
> fyang1_at_tiger.towson.eud
>
<snip>
This could be several things: make sure you are logging into Oracle with the same id the program uses. Put in some debug statements to make sure it's really executing all the way through the way you think it is. Make sure it's not core dumping. You might want to explicitly check the sqlca.sqlcode after each EXEC SQL just in case the whenever sqlerror isn't working for whatever reason. If it was working and you did everything right the table would be there.
-- --- Allen Kirby AT&T ITS Production Services akirby_at_att.com Alpharetta, GA.Received on Mon Mar 10 1997 - 00:00:00 CST