Click here to Skip to main content
15,892,643 members
Home / Discussions / C#
   

C#

 
GeneralRe: function conference Pin
asma_pfe1-May-08 0:09
asma_pfe1-May-08 0:09 
GeneralRe: function conference Pin
Christian Graus1-May-08 2:58
protectorChristian Graus1-May-08 2:58 
GeneralRe: function conference Pin
Bert delaVega1-May-08 4:12
Bert delaVega1-May-08 4:12 
GeneralRe: function conference Pin
asma_pfe2-May-08 3:21
asma_pfe2-May-08 3:21 
QuestionI am not able to see large icon in list view Pin
Naveed72730-Apr-08 21:48
Naveed72730-Apr-08 21:48 
AnswerRe: I am not able to see large icon in list view Pin
Christian Graus30-Apr-08 23:07
protectorChristian Graus30-Apr-08 23:07 
Questiontriggers with a stored procedure Pin
Member 400849230-Apr-08 21:37
Member 400849230-Apr-08 21:37 
AnswerRe: triggers with a stored procedure Pin
Christian Graus30-Apr-08 23:07
protectorChristian Graus30-Apr-08 23:07 
Questionrun asp.net appn on iis Pin
Member 443208630-Apr-08 21:02
Member 443208630-Apr-08 21:02 
AnswerRe: run asp.net appn on iis Pin
som.nitk30-Apr-08 21:35
som.nitk30-Apr-08 21:35 
AnswerRe: run asp.net appn on iis Pin
Christian Graus30-Apr-08 23:09
protectorChristian Graus30-Apr-08 23:09 
QuestionHow to get all files name from Property.Resourece Pin
Guru Call30-Apr-08 20:32
Guru Call30-Apr-08 20:32 
AnswerRe: How to get all files name from Property.Resourece Pin
Gopal.S1-May-08 1:34
Gopal.S1-May-08 1:34 
QuestionDisplaying lines of code as a program runs Pin
MarkB77730-Apr-08 20:13
MarkB77730-Apr-08 20:13 
AnswerRe: Displaying lines of code as a program runs Pin
Christian Graus30-Apr-08 20:15
protectorChristian Graus30-Apr-08 20:15 
GeneralRe: Displaying lines of code as a program runs Pin
Roger Alsing30-Apr-08 21:48
Roger Alsing30-Apr-08 21:48 
QuestionFile Structure Serialization Pin
Ian Uy30-Apr-08 20:05
Ian Uy30-Apr-08 20:05 
AnswerRe: File Structure Serialization Pin
carbon_golem1-May-08 2:59
carbon_golem1-May-08 2:59 
GeneralRe: File Structure Serialization Pin
Ian Uy1-May-08 3:05
Ian Uy1-May-08 3:05 
GeneralRe: File Structure Serialization Pin
carbon_golem1-May-08 3:41
carbon_golem1-May-08 3:41 
GeneralRe: File Structure Serialization Pin
Ian Uy1-May-08 3:49
Ian Uy1-May-08 3:49 
GeneralRe: File Structure Serialization Pin
carbon_golem1-May-08 3:57
carbon_golem1-May-08 3:57 
QuestionPlease Help !Query executing in oracle but not executing through code Pin
ravindradonkada30-Apr-08 19:46
ravindradonkada30-Apr-08 19:46 
<>Hi,

This is ravindra ,I created the following function and able to execute the followed query
successfully in sql plus but when i try to execute the same query through code,getting error like



Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.
Data type is not supported.







Create or Replace Function convert_time(datetime in timestamp, tz1 in varchar2, tz2
in varchar2)
Return timestamp with time zone
as
retval timestamp with time zone;
Begin
retval := from_tz(datetime, tz1) at time zone tz2;
return retval;
End;


select convert_time(to_timestamp('01/01/2006 23:45','mm/dd/yyyy
hh24:mi'),'US/Eastern','Turkey') from dual;




the .net code as follows


string conn = "Provider=MSDAORA.1;Password=;User ID=;Data Source=naradaon;Extended
Properties=Server=naradaon";

OleDbConnection con = new OleDbConnection(conn);

con.Open();

DataSet ds = new DataSet();

OleDbDataAdapter da = new OleDbDataAdapter("select from_tz(to_timestamp('01/01/2006
23:45','mm/dd/yyyy hh24:mi'),'-05:00') as hio from dual", con);


da.Fill(ds);


Please help me



thank you


<>
AnswerRe: Please Help !Query executing in oracle but not executing through code Pin
Christian Graus30-Apr-08 20:18
protectorChristian Graus30-Apr-08 20:18 
AnswerRe: Please Help !Query executing in oracle but not executing through code [modified] Pin
Mircea Puiu1-May-08 4:46
Mircea Puiu1-May-08 4:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.