Re: Q: No Pro*C code works

A copy of this was sent to Yan Zhou <yzhouy_at_yahoo.com> (if that email address didn't require changing) On Thu, 05 Aug 1999 11:28:44 -0400, you wrote:

>
>Hi there,
>
> I am new on Pro*C, please forgive me if I am asking stupid questions.
>Basically I am trying to run Pro*C to retrieve BLOB data from an
>Oracle8i table.
>The code and the error message from Pro*C/C++ compiler are enclosed. My
>problem
>is that I could not get any Pro*C code pre-compiled successfully, even
>with
>Oracle's demo *.PC file. I activiate the Pro*C/C++ compiler and load up
>a demo
>*.PC file from Oracle, the compiler keeps complaining (see the attached
>error message).
>
> I must have missed something like environment setting, options, etc.
>But, I
>could not find any documents to help me with that. What does
>it take to run Pro*C/C++ compiler ?
>

add:

parse=full

to the pro*c command line. Else it is expecting all host variables to be wrapped in an:

EXEC SQL BEGIN DECLARE SECTION;
...
EXEC SQL END DECLARE SECTION; set of tags..

> Any hint is greatly appreciated. I am running my code from a NT4.0
>workstation
>which has DB access to an Oracle8i server installed on NT4.0 server.
>
> By the way, I wish I could use plain Visual C++ (MFC) code to access
>LOB
>data in Oracle8i. But I have not had success yet. If any of you knows
>how to
>do that, please let me know.
>
> Thanks.
>
> Yan
> yzhou_at_lexmark.com
>
>

--
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 Thu Aug 05 1999 - 12:10:35 CDT