Home » Developer & Programmer » Precompilers, OCI & OCCI » XMLELEMENT TAG (Pro *c)
XMLELEMENT TAG [message #473366] Fri, 27 August 2010 10:28 Go to next message
sujeethkannan
Messages: 10
Registered: August 2010
Location: CHENNAI
Junior Member
if i run the pl /sql code its working fine without any error

EXEC SQL EXECUTE
declare
l_clob_xml_msg CLOB;
purge_dt DATE DEFAULT SYSDATE;
barcode_in CHAR(20) := 'TEST';
item_no CHAR(Cool := '133444';
type_c CHAR(1) := 'C';

BEGIN

SELECT xmlelement("Id",
xmlelement("barCode", trim(barcode_in)),
xmlelement("item", item_no),
xmlelement("typeC", type_c),
xmlelement("purDate", purge_dt )).getclobVal()
INTO l_clob_xml_msg
FROM dual;

test_msg_sp(l_clob_xml_msg );

END;
END-EXEC;

But when i run the above code in pro *c getting followign error

I have following code snippet in pro *c. I'm Constructing XML element and passing to SP using Clob data type.

When compling pro *c i'm getting following error for xmlelement key word mentioned below

SELECT xmlelement("Id",
.........1
PLS-S-00201, identifier 'XMLELEMENT' must be declared
Error at line 203, test.pc
SELECT xmlelement("Id",
.........1
PLS-S-00000, SQL Statement ignored

Please let me know any one have ideas.

Thanks,
kannan
Re: XMLELEMENT TAG [message #473378 is a reply to message #473366] Fri, 27 August 2010 10:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pro*C version?
Compilation options?

Regards
Michel
Re: XMLELEMENT TAG [message #473531 is a reply to message #473378] Mon, 30 August 2010 01:34 Go to previous messageGo to next message
sujeethkannan
Messages: 10
Registered: August 2010
Location: CHENNAI
Junior Member
My pro *c version is

Pro*C/C++: Release 10.2.0.4.0 - Production on Mon Aug 30 01:32:44 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

System default option values taken from: /opt/oracle/product/prodvers/precomp/admin/pcscfg.cfg

Thanks,
Kannan
Re: XMLELEMENT TAG [message #473543 is a reply to message #473531] Mon, 30 August 2010 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the command line you used to precompile?

Regards
Michel
Re: XMLELEMENT TAG [message #473578 is a reply to message #473543] Mon, 30 August 2010 07:34 Go to previous messageGo to next message
sujeethkannan
Messages: 10
Registered: August 2010
Location: CHENNAI
Junior Member
Updated as requested

[Updated on: Tue, 31 August 2010 06:54] by Moderator

Report message to a moderator

Re: XMLELEMENT TAG [message #473583 is a reply to message #473543] Mon, 30 August 2010 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I will not decypher what is the values used when you call proc.
Post what makefile executed.

Regards
Michel
Re: XMLELEMENT TAG [message #473588 is a reply to message #473583] Mon, 30 August 2010 08:49 Go to previous messageGo to next message
sujeethkannan
Messages: 10
Registered: August 2010
Location: CHENNAI
Junior Member
Thanks for your help!!
I'm nto clear on what you are expecting..Please let me know how to take that value ...

The following program build will be invoked first..then it will collect all required file from Version control then it will compile the program.


%If ! %Defined(__BLD_LB)
%Set __BLD_LB



%Set USE_LIB_SYS3D
%Set USE_LIB_SYS3D_UTIL_DATABASE
%Set USE_LIB_SYS3D_SOAP
%Set USE_LIB_SYS3D_LOGGER
%Set NO_LIB_SYS3D_PIDFILE
.Include "sys3d_libs.bld"

%If %Defined(USE_LIB_SYS3D_PIDFILE)
%Echo "Cannot use 'libsys3d_pidfile' logic."
%Echo "Please include 'NO_LIB_SYS3D_PIDFILE=1' on build command line".
%Abort 1
%Endif

#**************************************************************
# Dependency Macros (OBJS, LIBS, ...)
#**************************************************************

EXE= dsh00020
OBJS= dsh00020.o
Scanned_Objects=$(OBJS)


#**************************************************************
# Compiler and Linker Flags
#**************************************************************
CFLAGS_ALL =+ -DMAXMQBUFLEN=16384 -I. -DERR_BUF_LEN=4096
CFLAGS_ALL =+ -g


$(EXE): $(OBJS) $(SYS3D_OBJS) $(LIBS_$(ORA_CLIENT_LIB))


.Include <scandeps_inc.cfg>

.Include "sys3d_build.bld"
%Endif

Thanks,
kannan
Re: XMLELEMENT TAG [message #473593 is a reply to message #473588] Mon, 30 August 2010 09:16 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you call the makefile, it executes several, each step is determined by the dependencies, the command it executes (copy, delete, precompile, compile, link and so on) and the options on these commands.
At each step make displays the command it will execute.
I want this command for the proc step.

Regards
Michel
Previous Topic: Printing of the sqlstmt during execution
Next Topic: extproc OCI LOB Question
Goto Forum:
  


Current Time: Thu Mar 28 04:46:16 CDT 2024