Click here to Skip to main content
15,920,688 members
Home / Discussions / C#
   

C#

 
GeneralRe: Small problem with programming for hand held devices.. Pin
Ed.Poore20-Sep-06 23:51
Ed.Poore20-Sep-06 23:51 
GeneralRe: Small problem with programming for hand held devices.. Pin
$0.05$21-Sep-06 4:30
$0.05$21-Sep-06 4:30 
GeneralRe: Small problem with programming for hand held devices.. Pin
Ed.Poore21-Sep-06 4:48
Ed.Poore21-Sep-06 4:48 
QuestionAnyone know how to serialize a class to a string Pin
ToddHileHoffer20-Sep-06 9:25
ToddHileHoffer20-Sep-06 9:25 
AnswerRe: Anyone know how to serialize a class to a string Pin
Guffa20-Sep-06 10:00
Guffa20-Sep-06 10:00 
QuestionProblem with DatGridViewCell Tag Pin
~~~Johnny~~~20-Sep-06 8:47
~~~Johnny~~~20-Sep-06 8:47 
AnswerRe: Problem with DatGridViewCell Tag Pin
~~~Johnny~~~20-Sep-06 9:13
~~~Johnny~~~20-Sep-06 9:13 
Questioncalling oracle stored proc from c#..need help Pin
bnathvbdotnet20-Sep-06 8:07
bnathvbdotnet20-Sep-06 8:07 
Cry | :(( Cry | :(( I am trying to call a oracle stored procedure and can't get it work. I am not sure how to call this from c#.


C#:
[CODE]
OracleParameter ps1 = new OracleParameter("cryst_rep.ref_cur_type", OracleType.Cursor);
ps1.Direction = ParameterDirection.Output;


OracleParameter[] param = { ps1 };
ahpDataSet = aDataBase.ExecuteDataSet("ReconcileHardm", param);


[/CODE]


Oracle stored proc looks like this:

create or replace PROCEDURE ReconcileHardm(io_cursor IN OUT portfolios.cryst_rep.ref_cur_type) IS

tmpVar NUMBER;

BEGIN


-- Join the two temp tables and do the reconciliation
OPEN io_cursor FOR
SELECT FAS133.DEAL, HEDGES.HEDGE_DEAL, FAS133.MTC_MV, HEDGES.Instrument_MV, FAS133.HEDGE_MV, HEDGES.HEDGE_MV,
FAS133.MTC_CURRENT_PAR,HEDGES.INSTRUMENT_PAR FROM TEMP_FAS133_MAIN_COPY FAS133 INNER JOIN TEMP_HEDGES_MON_f HEDGES
ON FAS133.DEAL = HEDGES.HEDGE_DEAL
WHERE FAS133.HEDGE_MV<>HEDGES.HEDGE_MV OR FAS133.MTC_CURRENT_PAR<>HEDGES.INSTRUMENT_PAR
OR FAS133.MTC_MV <> HEDGES.Instrument_MV ORDER BY DEAL;

--io_cursor := v_cursor;



END ReconcileHardm;
QuestionMySQL Pin
TAREQ F ABUZUHRI20-Sep-06 7:34
TAREQ F ABUZUHRI20-Sep-06 7:34 
QuestionGeneric method - cast enum value? Pin
Member 9620-Sep-06 7:03
Member 9620-Sep-06 7:03 
AnswerRe: Generic method - cast enum value? [modified] Pin
led mike20-Sep-06 7:16
led mike20-Sep-06 7:16 
GeneralRe: Generic method - cast enum value? Pin
Member 9620-Sep-06 7:51
Member 9620-Sep-06 7:51 
AnswerRe: Generic method - cast enum value? [modified] Pin
Andrew Rissing20-Sep-06 8:14
Andrew Rissing20-Sep-06 8:14 
GeneralRe: Generic method - cast enum value? Pin
Member 9620-Sep-06 9:57
Member 9620-Sep-06 9:57 
Questionnew to c#: layout problems Pin
stefano bitossi20-Sep-06 6:55
stefano bitossi20-Sep-06 6:55 
AnswerRe: new to c#: layout problems Pin
Jun Du20-Sep-06 7:26
Jun Du20-Sep-06 7:26 
GeneralRe: new to c#: layout problems Pin
stefano bitossi21-Sep-06 0:57
stefano bitossi21-Sep-06 0:57 
AnswerRe: new to c#: layout problems Pin
Christian Graus20-Sep-06 11:45
protectorChristian Graus20-Sep-06 11:45 
QuestionGetting Screen Position of a control Pin
Nadia Monalisa20-Sep-06 6:51
Nadia Monalisa20-Sep-06 6:51 
AnswerRe: Getting Screen Position of a control Pin
Richard Isaac20-Sep-06 10:49
Richard Isaac20-Sep-06 10:49 
QuestionSystem sound volume balance Pin
Erikerikerikerikerassa20-Sep-06 6:33
Erikerikerikerikerassa20-Sep-06 6:33 
QuestionExam 70-316 Pin
StyleGuide20-Sep-06 5:20
StyleGuide20-Sep-06 5:20 
AnswerRe: Exam 70-316 Pin
Syed Mujtaba Hassan22-Sep-06 23:30
Syed Mujtaba Hassan22-Sep-06 23:30 
QuestionGetting a bitmap from a DirecX Surface? Pin
Archimagus20-Sep-06 5:15
Archimagus20-Sep-06 5:15 
QuestionWhich is faster...remoting or TCP Pin
AmitDey20-Sep-06 5:06
AmitDey20-Sep-06 5:06 

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.