• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1430
  • Last Modified:

Compiling a demo program

Hi,
    I have problem compiling a demo program called cv_demo.pc in $ORACLE_HOME/7.3.2/precomp/demo/proc
   I used "make -f proc.mk cv_demo" and got the following results :
   Semantic error at line 69, column 18, file cv_demo.pc:
        EXEC SQL EXECUTE
.................1
(1) PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used
0
Rita060297
Asked:
Rita060297
  • 2
  • 2
1 Solution
 
poncejuaCommented:
You will get this error if you have not run the "calldemo"  
script before precompiling your program.

You should try to execute the sample9 demo by logging into  
sqlplus as shown below:  
 
     % scott/tiger for sample9
 
     % @$ORACLE_HOME/proc/demo/calldemo.sql  
     
*** for 7.3.x
 
     % scott/tiger for sample9
 
     % @$ORACLE_HOME/precomp/demo/sql/calldemo.sql    
 
You can now compile and execute the sample9 demo program.

If everything works fine try with your program. BTW, if you need something else please don't hesitate to contact me to my e-mail address: jmponcemartinez@hotmail.com.

Best regards,

Juan Manuel Ponce Martinez
DBA - Buenos Aires - Argentina
 
0
 
Rita060297Author Commented:
I have done as accordingly and the results are the same for compiling sample9.pc
0
 
poncejuaCommented:
Try to execute the make command adding the sqlcheck=semantics at the end.
0
 
Rita060297Author Commented:
I tried "sqlcheck=semantics userid=scott/tiger" and it works!

Thanks!


0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now