Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

the problem when request base64 string

899663Dec 31 2011 — edited Jan 2 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2012
Added on Dec 31 2011
3 comments
547 views