Home » SQL & PL/SQL » SQL & PL/SQL » In oracle Httpuritype - Not getting the output correctly (Oracle 11g)
In oracle Httpuritype - Not getting the output correctly [message #563346] Mon, 13 August 2012 02:11 Go to next message
abirami.thirunavukkarasu
Messages: 28
Registered: August 2012
Location: Bangalore
Junior Member
The thing is I am not getting any output when i run your procedure.
Should I need to set any nls language? .. even i try to run below qry from the another thread,

column french format a20
with t as (
select 'fish' txt from dual union all
select 'dog' txt from dual union all
select 'cat' txt from dual
)
select txt english,
regexp_substr(tr,'<span[^>]*>(.*)',1,1,'i',1) french
from (
select txt,
httpuritype('translate.google..../?hl=en&layout=1&eotf=1&sl=en&tl=fr&text='||utl_url.escape(txt)||'#').getclob() tr
from t
)
/

My output is blank for the french values. I am sure that I missing something, But i dont know what I am missing . Please advice.
Please not currently my CHARACTER SET WE8MSWIN1252
Re: In oracle Httpuritype - Not getting the output correctly [message #563348 is a reply to message #563346] Mon, 13 August 2012 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
'translate.google..../


It is not a valid URL.

Regards
Michel
Re: In oracle Httpuritype - Not getting the output correctly [message #563639 is a reply to message #563346] Thu, 16 August 2012 04:00 Go to previous messageGo to next message
abirami.thirunavukkarasu
Messages: 28
Registered: August 2012
Location: Bangalore
Junior Member
The reason is - i am not allowed to give the complete URL here. Since this is my first post....
the complete URL will go like this... and you have to add http in front with forward slash

translate.google.com/?hl=en&layout=1&eotf=1&sl=
Re: In oracle Httpuritype - Not getting the output correctly [message #563645 is a reply to message #563639] Thu, 16 August 2012 05:17 Go to previous message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Barbara's translation function.

Regards
Michel

[Updated on: Thu, 16 August 2012 05:19]

Report message to a moderator

Previous Topic: How does DBMS_SQL differ from Native Dynamic Code
Next Topic: Combining overlapping dates
Goto Forum:
  


Current Time: Sat Dec 20 17:29:23 CST 2014

Total time taken to generate the page: 0.07232 seconds