Re: PL/SQL Blocks Embedded in Pro*C
Date: 1996/03/24
Message-ID: <4j3rc3$hap_at_news.Belgium.EU.net>#1/1
In article <3154AE16.4E6C_at_Symbios.com>, Tammam Al-Hamwy
(Tammam.Al-Hamwy_at_Symbios.com) says...
!>
!>I'm new to this, so please bare with me ...
!>
!>I'm trying to execute a PL/SQL block inside my C program.
!>I'm following the PL/SQL User's Guide & Reference examples to
!>get me going.
!>
!>My Code:
!>
!> /* some C Code */
!>
!> EXEC SQL EXECUTE
!> BEGIN
!> package_name.proc_name(parameter);
!> END;
!> END-EXEC;
!>
!> /* some more C Code */
!>
!>The problem is when I compile the darn thing...
!>Again I'm using the supplied proc.mk file to make it
!>calling it as follows:
!> make -f proc.mk EXEC=myappl OBJS=myappl.o
!>
!>I get the following:
!>
!>Pro*C/C++: Release 2.1.2.0.0 - Production on Sat Mar 23 17:42:36 1996
!>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
!>System default option values taken from: /usr/oracle/proc/pmscfg.h
!>Semantic error at line 378, column 14, file grad.pc:
!> EXEC SQL EXECUTE
!>.............1
!>(1) PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL
!!>
!> blocks are used
!>*** Error code 1
!>make: Fatal error: Command failed for target `grad.c'
!>
!>
!>In that proc.mk file, I have the following line:
!> PROCPLSFLAGS= sqlcheck=semantics userid=$(USERID) dbms=v6_char
!>
!>
!>
!>Any help is much appreciated..
!>
!>Tammam
Check the proc.mk, even though PROCPLSFLAGS gets set, it's not necessarily being used!
maybe you could add it to /usr/oracle/proc/pmscfg.h?
--
Kind reGards
\ / |
X |
/ \ s
Gerard
Received on Sun Mar 24 1996 - 00:00:00 CET