OraFAQ Forum: Precompilers, OCI & OCCI » Problems with calling Package variables

Home » Developer & Programmer » Precompilers, OCI & OCCI » Problems with calling Package variables (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:09:55 CST 2024