Solved

PLS-S-00201 using Pro*C

Posted on 2001-06-18
4
4,093 Views
Last Modified: 2012-08-13
In my search looking for why sqlcxt is Seg Faulting on me I used the SQLCHECK=FULL when running proc. I get 3 of the same errors on 3 different SQL statements.
SQL:
EXEC SQL SELECT value
INTO :value
FROM existing_table
WHERE name = 'var';

ERROR:
Error at line 96, column 5 in file transactor.pc
96 EXEC SQL SELECT value
96 ....1
96 PLS-S-00201, identifier 'EXISTING_TABLE' must be declared
Error at line 96, column 5 in file transactor.pc
96 EXEC SQL SELECT value
96 ....1
96 PLS-S-00000, SQL Statement ignored
Error at line 96, column 5 in file transactor.pc
96 EXEC SQL SELECT value
96 ....1
96 PCC-S-02346, PL/SQL found semantic errors


The funny part is I have another SQL statement that is exactly the same, but looks for a different 'name'.

0
Comment
Question by:majorspank
4 Comments
 
LVL 3

Expert Comment

by:mathavra
ID: 6204514
If you stil facing the error and want to solve the problem, then try the following. OR, if you want to get more opinion on why the error is occuring, then please post the other "SQL" statements also.


SOLUTIION:
----------

These errors are always related to the configuration file.
If the configuration file (pcscfg.cfg) has sqlcheck=full, then the following errors will result:

   PCC-F-02209
   PCC-S-02201
   Error at line 0, column 0 in file sample1.pc
   PCC-F-02102, Fatal error while doing C preprocessing
   *** Exit 1
   Stop.
   *** Exit 1

There are incorrect settings for the PRO*C precompiler.

VERIFY ALL SETTINGS IN CONFIGURATION FILE ARE CORRECT AS BELOW.

On Most Unix Platforms
----------------------

This can be resolved by setting:

   sqlcheck=syntax

in the configuration file.

On Digital Unix
---------------

To resolve these errors, make sure that the configuration file (pcscfg.cfg)
has the following entry:

   code=ansi_c

PATH:
-----
($ORACLE_HOME/precomp/admin/pcscfg.cfg).
0
 
LVL 1

Author Comment

by:majorspank
ID: 6207373
I wasn't very clear.  Originally I had SQLCHECK=SYNTAX, which is the default for proc, but as a further check of my code I used the SQLCHECK=FULL flag to see if it might be an improper SQL statement.  

Are you saying that this will happen regularily on valid SQL statements when the SQLCHECK flag is set to FULL?


Also, my seg fault problem stems from the code generated from proc.  When I run a test on the function I don't get a seg fault, but when I integrate the function into the greater project I get a seg fault on a sqlcxt() call.  The test is just adding a main() to the .pc file and running it stand alone.  Do you know of any issue regarding sqlcxt() crashes?

Thanks for your help.
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7033775
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks to all,
Moondancer - EE Moderator

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 7046067
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
compre toata in where clue oracle 4 55
Convert Oracle data into XML document 2 55
How to connect SQL Server from my Oracle database? 11 69
Get the parent node - XMLTYPE 9 56
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now