XMLELEMENT TAG [message #473366] |
Fri, 27 August 2010 10:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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( := '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 #473531 is a reply to message #473378] |
Mon, 30 August 2010 01:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #473588 is a reply to message #473583] |
Mon, 30 August 2010 08:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|