dbTalk Databases Forums  

Pro*C and empty output files

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Pro*C and empty output files in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
johnebullock@hotmail.com
 
Posts: n/a

Default Pro*C and empty output files - 06-05-2007 , 11:02 AM






We are running Oracle 10.2.0 under Linux.

How can I stop the Pro*C compiler from producing what look like
temporary files? They are created in groups of three and are all
empty. Here are some examples:

-rw------- 1 z005218 users 0 May 24 13:54 tpCzy2vx
-rw------- 1 z005218 users 0 May 24 13:54 tpIVsHCX
-rw------- 1 z005218 users 0 May 24 13:54 tpYMEmzf

Thanks in advance for your help.


Reply With Quote
  #2  
Old   
Sidhu
 
Posts: n/a

Default Re: Pro*C and empty output files - 06-05-2007 , 11:14 AM






On Jun 5, 9:02 pm, johnebull... (AT) hotmail (DOT) com wrote:
Quote:
We are running Oracle 10.2.0 under Linux.

How can I stop the Pro*C compiler from producing what look like
temporary files? They are created in groups of three and are all
empty. Here are some examples:

-rw------- 1 z005218 users 0 May 24 13:54 tpCzy2vx
-rw------- 1 z005218 users 0 May 24 13:54 tpIVsHCX
-rw------- 1 z005218 users 0 May 24 13:54 tpYMEmzf

Thanks in advance for your help.
are these files generated when you compile some program or what ?

Sidhu



Reply With Quote
  #3  
Old   
johnebullock@hotmail.com
 
Posts: n/a

Default Re: Pro*C and empty output files - 06-05-2007 , 11:30 AM



On Jun 5, 12:14 pm, Sidhu <amardeepsi... (AT) gmail (DOT) com> wrote:
Quote:
On Jun 5, 9:02 pm, johnebull... (AT) hotmail (DOT) com wrote:

We are running Oracle 10.2.0 under Linux.

How can I stop the Pro*C compiler from producing what look like
temporary files? They are created in groups of three and are all
empty. Here are some examples:

-rw------- 1 z005218 users 0 May 24 13:54 tpCzy2vx
-rw------- 1 z005218 users 0 May 24 13:54 tpIVsHCX
-rw------- 1 z005218 users 0 May 24 13:54 tpYMEmzf

Thanks in advance for your help.

are these files generated when you compile some program or what ?

Sidhu
They are generated when we precompile a Pro*C file.

John



Reply With Quote
  #4  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Pro*C and empty output files - 06-06-2007 , 10:05 AM



On Tue, 05 Jun 2007 09:30:09 -0700, johnebullock wrote:

Quote:
They are generated when we precompile a Pro*C file.

John
Run the precompiler under strace -o /tmp/proc.out -e trace=file and you
should be able to see what's going on. As the the groups of three, haven't
you ever seen "Charmed"? It's the power of three.


--
http://www.mladen-gogala.com


Reply With Quote
  #5  
Old   
johnebullock@hotmail.com
 
Posts: n/a

Default Re: Pro*C and empty output files - 06-07-2007 , 02:03 PM



On Jun 6, 11:05 am, Mladen Gogala <mgogala.SPAM... (AT) not-at-verizon (DOT) net>
wrote:
Quote:
On Tue, 05 Jun 2007 09:30:09 -0700,johnebullockwrote:
They are generated when we precompile a Pro*C file.

John

Run the precompiler under strace -o /tmp/proc.out -e trace=file and you
should be able to see what's going on. As the the groups of three, haven't
you ever seen "Charmed"? It's the power of three.

--http://www.mladen-gogala.com
Mladen,

Thanks for telling me about strace, I will be using this tool in the
future for sure.

What strace told me about this problem in particular is that there
seems to have been a bug in the 10.2.0.1.0 Pro*C precompiler that was
not cleaning up some temp files. The 10.2.0.3.0 version does not have
this problem, as I ran strace on systems with both Oracle versions.

So I guess the power of three, as in the third version of 10.2, is
charmed.

John



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.