Click here to Skip to main content
15,906,645 members
Home / Discussions / C#
   

C#

 
GeneralRe: Run time declared DGV Pin
baranils17-Mar-08 20:09
baranils17-Mar-08 20:09 
QuestionHow to retrieve selected value from list view? Pin
yuenli17-Mar-08 11:59
yuenli17-Mar-08 11:59 
AnswerRe: How to retrieve selected value from list view? Pin
mmikey717-Mar-08 13:51
mmikey717-Mar-08 13:51 
AnswerRe: How to retrieve selected value from list view? Pin
Xmen Real 17-Mar-08 15:28
professional Xmen Real 17-Mar-08 15:28 
GeneralArithmetic Problem Pin
CNewbie17-Mar-08 11:34
CNewbie17-Mar-08 11:34 
GeneralRe: Arithmetic Problem Pin
Luc Pattyn17-Mar-08 11:50
sitebuilderLuc Pattyn17-Mar-08 11:50 
GeneralRe: Arithmetic Problem Pin
mmikey717-Mar-08 13:26
mmikey717-Mar-08 13:26 
QuestionUDT - InvalidOperiationException: invalid Value for OracleObjectMappingAttribute Pin
faehne17-Mar-08 11:04
faehne17-Mar-08 11:04 
Hello..

I've got an InvalidOperationException: invalid Value vor the OracleObjectMappingAttribute nNR

Could NET have a problem with casting NUMBER to int? Or have i to do something
special, because I'm using a OUT-only Parameter?

Here are my code:

PLSQL:
-------------
create type TESTOBJ as OBJECT (
nNR NUMBER;
sTEXT VARCHAR2(20);
)

create testproc(p_testobj OUT TESTOBJ)
as
v_testobj TESTOBJ := TESTOBJ(1,'Test');
begin
p_testobj := v_testobj;
end;

C# the Mapped OBj:
-------------------------------
public class OracleXTBQueueObj : IOracleCustomType
{

private int nr;

[OracleObjectMappingAttribute("nNR")]
public int NR {
get { return nr; }
set { nr = value; }
}

private string tEXT;

[OracleObjectMappingAttribute("sTEXT")]
public string TEXT
{
get { return tEXT; }
set { tEXT = value; }
}

public virtual void FromCustomObject(OracleConnection con, IntPtr pUdt)
{
OracleUdt.SetValue(con, pUdt, "nNR", this.NR);
OracleUdt.SetValue(con, pUdt, "sTEXT", this.TEXT);
}

public virtual void ToCustomObject(OracleConnection con, IntPtr pUdt)
{
this.NR = ((int)(OracleUdt.GetValue(con, pUdt, "nNR")));
this.TEXT = ((string)(OracleUdt.GetValue(con, pUdt, "sTEXT")));
}
}

C# the Factory:
-------------------------------
[OracleCustomTypeMappingAttribute("USR.TESTOBJ")]
public class OracleXTBQueueObjFactory : IOracleCustomTypeFactory
{
public IOracleCustomType CreateObject()
{
OracleXTBQueueObj obj = new OracleXTBQueueObj();
return obj;
}
}

C# the function, callin the PROCEDURE:
------------------------------------------------------------
public static void GetOO(OracleConnection conn)
{
OracleCommand cmd = new OracleCommand("UDT_TESTPROC", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;

OracleParameter paramDaten = new OracleParameter("p_testobj", OracleDbType.Object, ParameterDirection.Output);
paramDaten.UdtTypeName = "USR.TESTOBJ";
cmd.Parameters.Add(paramDaten);

try { cmd.ExecuteNonQuery(); }
catch (Exception ex) //InvalidOperationException
{
Console.Out.WriteLine(ex.Message)
}
Console.In.ReadLine();
paramDaten.Value.ToString();

}

-----
Hope somebody can help me

thx in advance
faehne
Questionwindows service using C# Pin
Knowledgestudent17-Mar-08 10:55
Knowledgestudent17-Mar-08 10:55 
GeneralRe: windows service using C# Pin
Mark J. Miller17-Mar-08 11:07
Mark J. Miller17-Mar-08 11:07 
GeneralRe: windows service using C# Pin
PIEBALDconsult17-Mar-08 12:15
mvePIEBALDconsult17-Mar-08 12:15 
QuestionRe: windows service using C# Pin
Knowledgestudent18-Mar-08 0:03
Knowledgestudent18-Mar-08 0:03 
GeneralRe: windows service using C# Pin
Stu Richardson18-Mar-08 2:50
Stu Richardson18-Mar-08 2:50 
QuestionRe: windows service using C# Pin
Knowledgestudent18-Mar-08 23:48
Knowledgestudent18-Mar-08 23:48 
GeneralRe: windows service using C# Pin
Stu Richardson19-Mar-08 0:19
Stu Richardson19-Mar-08 0:19 
QuestionRe: windows service using C# Pin
Knowledgestudent19-Mar-08 0:35
Knowledgestudent19-Mar-08 0:35 
GeneralRe: windows service using C# Pin
Stu Richardson19-Mar-08 1:09
Stu Richardson19-Mar-08 1:09 
GeneralRe: windows service using C# Pin
Knowledgestudent19-Mar-08 2:19
Knowledgestudent19-Mar-08 2:19 
GeneralRe: windows service using C# Pin
PIEBALDconsult18-Mar-08 6:14
mvePIEBALDconsult18-Mar-08 6:14 
NewsWhirlwind 1 -- Generics now posted on Channel 9 Pin
brucedkyle17-Mar-08 9:38
brucedkyle17-Mar-08 9:38 
GeneralRe: Whirlwind 1 -- Generics now posted on Channel 9 Pin
pmarfleet17-Mar-08 10:42
pmarfleet17-Mar-08 10:42 
GeneralRe: Whirlwind 1 -- Generics now posted on Channel 9 Pin
Not Active17-Mar-08 11:25
mentorNot Active17-Mar-08 11:25 
QuestionDebug into unmanage code?? Pin
Small Rat17-Mar-08 9:13
Small Rat17-Mar-08 9:13 
GeneralRe: Debug into unmanage code?? Pin
led mike17-Mar-08 9:16
led mike17-Mar-08 9:16 
GeneralRe: Debug into unmanage code?? Pin
Small Rat17-Mar-08 9:20
Small Rat17-Mar-08 9:20 

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.