Re: PRO*C pre-compilation error

this assumes an OPS$ logon to the database. You will need to check that your environment is connecting to the database you expect, and that the OPS$ account of the user performing the compile has visibility of the DBMS_APPL_SERVER package.

It maybe that you need to specify the database user (as suggested by Thomas Kyte)

Sven Janssen <sven_at_intershop.de> wrote in article <359A39A3.372EC200_at_intershop.de>...
> 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.
>
> Thanx
>
> Sven Janssen
>
>
>
>
Received on Thu Jul 02 1998 - 14:04:54 CEST