Home » Developer & Programmer » Precompilers, OCI & OCCI » Problems with calling Package variables (Oracle 10g)
icon5.gif  Problems with calling Package variables [message #350228] Wed, 24 September 2008 08:04
ujjvala
Messages: 1
Registered: September 2008
Junior Member
Hi,

I'm using the following code in Pro*C file to call a variable from a database package. Prior to adding this function all was fine and the code executed properly. But inorder to execute the embedded query I needed to add "sqlcheck=semantics" and userid parameter in the precompile call. and I get a whole list of other Shocked errors pointing to different queries that executed properly before.

EXEC SQL EXECUTE
BEGIN
:h_file_loc:h_file_loc_Ind:= PACKAGE1.TEMP_DIRECTORY;
END;
END-EXEC;



Error at line 2117, column 4 in file ./MyProc.pc
EXEC SQL INSERT INTO MyTable
...1
PLS-S-00390, undefined column 'WBS_CODE' in INSERT statement
Error at line 2117, column 4 in file ./MyProc.pc
EXEC SQL INSERT INTO MyTable
...1
PLS-S-00000, SQL Statement ignored
Semantic error at line 2117, column 4, file ./MyProc.pc:
EXEC SQL INSERT INTO MyTable
...1
PCC-S-02346, PL/SQL found semantic errors
EXEC SQL DECLARE column1 C
URSOR FOR SELECT SUM(col),PMO_ORASTD.JULIAN_DAY(day)
................................................1
PLS-S-00201, identifier 'PMO_COMP_ACTUAL' must be declared
EXEC SQL DECLARE column1 C
URSOR FOR SELECT SUM(col),PMO_ORASTD.JULIAN_DAY(day)
................................................1
PLS-S-00000, SQL Statement ignored
Semantic error at line 3611, column 49, file ./MyProc.pc:
EXEC SQL DECLARE column1 C
URSOR FOR SELECT SUM(col),PMO_ORASTD.JULIAN_DAY(day)
................................................1
PCC-S-02346, PL/SQL found semantic errors
SELECT w.colx
.....1
PLS-S-00414, no column 'ELEMENT_NAME' in table
SELECT w.colx
.....1
PLS-S-00000, SQL Statement ignored
Semantic error at line 4405, column 6, file ./MyProc.pc:
SELECT w.colx
.....1
PCC-S-02346, PL/SQL found semantic errors
SELECT (DECODE(D.DEP_TYPE,1,'0010:',2,'0
040:',3,'0020:',0,'0080:','0000'))
.....1
PLS-S-00358, column 'ELEMENT_ID' exists in more than one table; use qualifier
SELECT (DECODE(D.DEP_TYPE,1,'0010:',2,'0
040:',3,'0020:',0,'0080:','0000'))
.....1
PLS-S-00000, SQL Statement ignored
Semantic error at line 7792, column 6, file ./MyProc.pc:
SELECT (DECODE(D.DEP_TYPE,1,'0010:',2,'0
040:',3,'0020:',0,'0080:','0000'))
.....1
PCC-S-02346, PL/SQL found semantic errors
SELECT ColB
AS ColB
......1
PLS-S-00201, identifier 'ColA' must be declared
SELECT ColB
AS ColB
......1
PLS-S-00000, SQL Statement ignored
Semantic error at line 22676, column 7, file ./MyProc.pc:
SELECT ColB
AS ColB
......1
PCC-S-02346, PL/SQL found semantic errors

Any help is appreciated.

thanks in advance.
Ujjvala


Previous Topic: [ORA-01480] Error while assigning value to a variable
Next Topic: PRO*C Coding Standards
Goto Forum:
  


Current Time: Thu Dec 08 14:03:30 CST 2016

Total time taken to generate the page: 0.08774 seconds