| PLS-00302: component 'GETBLOBVAL' must be declared [message #199496] |
Tue, 24 October 2006 15:34  |
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
|
Senior Member |
|
|
Hi Friends,
I have one problem while writing xmlfile in a perticular directory.
l_XMLFile := utl_file.fopen('Test', 'test.xml','w');
l_blob := l_xml.getblobval (31);
For the second line i am facing the error.
PLS-00302: component 'GETBLOBVAL' must be declared
Can anyone please tell me how to solve the problem?
Thnaks for any type of help.
Thanks in advance.
Amol.
|
|
|
|
|
|
| Re: PLS-00302: component 'GETBLOBVAL' must be declared [message #199581 is a reply to message #199496] |
Wed, 25 October 2006 03:13  |
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
|
Senior Member |
|
|
Hi Littlefoot,
Thanks a lot for your reply.
I searched in my file for any wrong declaration.
But, i could not found the solution.
Can you please guide me on this.
Below is the code for writing into XML file.
/***********************************************/
CREATE OR REPLACE PROCEDURE Sp_Transport_Order_Write_Xml (
p_BOOKING_SEQ booking.BOOKING_SEQ%TYPE
) AS
CURSOR c_xml ( pc_data_seq booking.BOOKING_SEQ%TYPE ) IS
SELECT result
FROM V_TRANSPORTORDERMAIN_XML
WHERE BOOKING_SEQ = pc_data_seq ;
s_xml c_xml%ROWTYPE ;
l_XMLFile utl_file.file_type ;
l_month VARCHAR2(7) ;
l_Dir VARCHAR2(78) ;
l_blob BLOB ;
l_xml XMLTYPE ;
BEGIN
l_Dir := 'test';
l_XMLFile := utl_file.fopen(l_Dir, 'gpa_' || 1 || '.xml','w');
OPEN c_xml ( p_BOOKING_SEQ ) ;
FETCH c_xml INTO s_xml ;
l_xml := s_xml.result ;
l_blob := l_xml.getblobval (NLS_CHARSET_ID('UTF8'));
-- l_blob := l_xml.getblobval (NLS_CHARSET_ID('31'));
utl_file.put_raw( l_XMLFile , l_blob ) ;
CLOSE c_xml ;
utl_file.fclose(l_XMLFile);
END;
/****************************************************/
Thanks in advance.
Amol.
|
|
|
|
| Re: PLS-00302: component 'GETBLOBVAL' must be declared [message #199611 is a reply to message #199581] |
Wed, 25 October 2006 04:28 |
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
|
Senior Member |
|
|
Hi friends,
I searched for error ""PLS-00302: component 'GETBLOBVAL' must be declared.
I find that 'GETBLOBVAL' function/procedure is only available in oracle 10g and not available in Oracle 9i.
Can anyone please tell me,
1:> Is it really not possible in oracle 9i???
2:> If not then how can i incoporate oracle 10g feature in oracle 9i.
3:> If it is not possible then can anyone tell me how can i write through oracle 9i.
I will be thankful if anyone help me.
Amol.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
