Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Use the SQLCHECK=SEMANTICS option and USERID on pro*c program

Dingmin MinDec 19 2022

Hello,
This is Dmin. I am new to pro*c.
When I tried to compare a program, I got "PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used" error.
The error point to E in SQL part
BEGINEXEC SQL **E**XECUTE
BEGIN
.......
END;
END-EXEC;
3.I searched the error and got a answer said "Use the SQLCHECK=SEMANTICS option. This also requires that the USERID connect option be given"
4.Can someone show me an example on how to add
SQLCHECK=SEMANTICS and USERID please.
Thank you
Dmin

Comments
Post Details
Added on Dec 19 2022
1 comment
405 views