Re: Q: eXt. Procs.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 04 Aug 1999 15:30:02 GMT
Message-ID: <37ae5538.7725959@newshost.us.oracle.com>

A copy of this was sent to "huh"
(if that email address didn't require changing) On Wed, 4 Aug 1999 10:37:26 +0200, you wrote:

>
>Thomas,
>
>Thanks for your response, it is appreciated even if it makes
>me sad :-).
>
>> A copy of this was sent to "huh" -> <-
>> (if that email address didn't require changing)
>> On Tue, 3 Aug 1999 12:38:04 +0200, you wrote:
>
>However I BEG you, PLEASE DON'T INCLUDE my
>e-mail address in your reply. If you wish so, please malform
>it at least to disallow spambots bombing my box (but allowing
>humans understand it)..
>

I took it out this time however:

i probably won't next time. takes too much time to follow lots of directions on how to answer each specific post. I just answer the questions -- don't even see the signature many times.
its in the posting header anyway, removing the from the body does *NOTHING*. You'll have to munge your return address yourself if you don't want them to get it.

Look at the raw usenet headers, your posting had these:

Path:
inet16.us.oracle.com!paloalto-snf1.gtei.net!news.gtei.net!newsfeed.stanford.edu!skynet.be!news-feed1.eu.concert.net!news.cesnet.cz!news.felk.cvut.cz!not-for-mail From: "huh" <your email id was right here> Newsgroups: comp.databases.oracle.server Subject: Re: Q: eXt. Procs. - callbacks Date: Wed, 4 Aug 1999 10:37:26 +0200
Organization: Czech Technical University Lines: 39

Message-ID: <7o8u63$3035$1_at_ns.felk.cvut.cz>
References: <7o6gru$2pj6$2_at_ns.felk.cvut.cz>
<37ab0c02.8718546_at_newshost.us.oracle.com>

NNTP-Posting-Host: firewall.bsc.cz
Mime-Version: 1.0
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Keywords: .

X-no-spam: yes
X-no-archive: yes
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

Xref: inet16.us.oracle.com comp.databases.oracle.server:68811

the spambots go after the headers first. They'll get your email right from there. I changed it to <your email id was right here> for now.

I post lots. I put my email in there lots. In the last 2 weeks i've gotten less then 40 spams total, thats 3 or 4 a day. email filters got 99% of them.

>>
>> In Oracle8.0, extprocs that do callbacks must use OCI.
>> In Oracle8i, release 8.1, they may use either OCI or Pro*C.
>>
>
>Let me ask... As far as I understand it Pro*C is a translator - it converts
>one
>text file to another text file (like standard C preprocessor), doesn't it?

yes, pro*c is a preprocessor.

>It replaces EXEC SQL lines with respective OCI calls, or am I wrong?

it replaces PROC with sqllib calls -- sqllib being sort of like OCI but different. It is an internal api that is gets translated to.

>So both executables (either written in pure OCI or Pro*C - embedded sql)
>communicate with DB engine through the OCI - is there any essential
>difference
> between OCI and Pro*C?

there are things you can do in OCI that you cannot do in pro*c (not many but some).

some people find pro*c to be more productive then oci (faster the code). some people hate the concept of a precompiler.

>
>I guess they extended (in O8i R8.1) Pro*C capabilities to support
>::OCIExtProcGetEnv

yes...

>
>TIA
--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 04 1999 - 10:30:02 CDT