Re: PRO*C pre-compilation error

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 01 Jul 1998 15:00:06 GMT
Message-ID: <359a4edc.2877277_at_192.86.155.100>

A copy of this was sent to Sven Janssen <sven_at_intershop.de> (if that email address didn't require changing) On Wed, 01 Jul 1998 15:29:07 +0200, you wrote:

>We use Pro*C 2.2.3.0.0 on NT and
>Pro*C 2.2.3.0.0 on AIX to use Oracles PLEX
>utility. We got problems to compile the sample
>code like (main.pc):
>
>...
>
> EXEC SQL EXECUTE
> BEGIN
> DBMS_APPL_SERVER.S_REQUEST(:returnpipe,:command,:in);
> END;
> END-EXEC;
>
>...
>
>proc22 code=ansi_c sqlcheck=semantics main.pc
>
>Pro*C/C++: Release 2.2.3.0.0 - Production on Tue Jun 30 21:01:48 1998
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>System default option values taken from: D:\ORANT\pro22\pmscfg.cfg
>
>DBMS_APPL_SERVER.S_REQUEST(:returnpipe,:command,:in);
>........................1
>(1) PCC-S-02201, identifier 'DBMS_APPL_SERVER.S_REQUEST' must be
>declared
>
>Under aix and Pro*C 2.2.4.0.0 it is the same problem.
>
>We looked at a lot of PRO*C sample programs, but all the
>stuff could not be compiled. Do we miss a newer PRO*C
>Pre-compiler, a command line option or whatever?
>We only want to execute a procedure.
>

command line option, you need to add

user=username/password

to the proc compile line...

>Thanx
>
>Sven Janssen
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jul 01 1998 - 17:00:06 CEST