Click here to Skip to main content
15,914,795 members
Home / Discussions / C#
   

C#

 
AnswerRe: Closing a exe file Pin
Nuri Ismail18-Feb-09 3:08
Nuri Ismail18-Feb-09 3:08 
GeneralRe: Closing a exe file Pin
mrithula818-Feb-09 18:11
mrithula818-Feb-09 18:11 
GeneralRe: Closing a exe file [modified] Pin
Nuri Ismail18-Feb-09 21:49
Nuri Ismail18-Feb-09 21:49 
GeneralRe: Closing a exe file Pin
mrithula818-Feb-09 23:11
mrithula818-Feb-09 23:11 
GeneralRe: Closing a exe file Pin
Nuri Ismail18-Feb-09 23:14
Nuri Ismail18-Feb-09 23:14 
Questiondraw a line similar to the one present in ms word Pin
sabeel alwosol18-Feb-09 2:59
sabeel alwosol18-Feb-09 2:59 
AnswerRe: draw a line similar to the one present in ms word Pin
Thomas Stockwell18-Feb-09 4:22
professionalThomas Stockwell18-Feb-09 4:22 
QuestionCompare file length and lines of data in 2 files inside a zip file Pin
Member 322226418-Feb-09 2:56
Member 322226418-Feb-09 2:56 
AnswerRe: Compare file length and lines of data in 2 files inside a zip file Pin
Deresen18-Feb-09 4:03
Deresen18-Feb-09 4:03 
QuestionCross domain AD search Pin
NanaAM18-Feb-09 2:03
NanaAM18-Feb-09 2:03 
QuestionUnwanted Dash in HTTP request string Pin
cfoxtrot18-Feb-09 1:44
cfoxtrot18-Feb-09 1:44 
QuestionUsing PowerPoint Application in .net Pin
nameen18-Feb-09 1:06
nameen18-Feb-09 1:06 
Questiondrawing lines at runtime Pin
maisa.z18-Feb-09 0:30
maisa.z18-Feb-09 0:30 
AnswerRe: drawing lines at runtime Pin
J4amieC18-Feb-09 0:41
J4amieC18-Feb-09 0:41 
AnswerRe: drawing lines at runtime Pin
dan!sh 18-Feb-09 2:15
professional dan!sh 18-Feb-09 2:15 
QuestionFinding controls in datagridview dynamically Pin
Nitin K17-Feb-09 23:52
Nitin K17-Feb-09 23:52 
AnswerRe: Finding controls in datagridview dynamically Pin
Calin Tatar18-Feb-09 0:50
Calin Tatar18-Feb-09 0:50 
GeneralRe: Finding controls in datagridview dynamically Pin
Nitin K18-Feb-09 2:20
Nitin K18-Feb-09 2:20 
GeneralRe: Finding controls in datagridview dynamically Pin
Calin Tatar18-Feb-09 2:26
Calin Tatar18-Feb-09 2:26 
GeneralRe: Finding controls in datagridview dynamically Pin
Calin Tatar18-Feb-09 2:35
Calin Tatar18-Feb-09 2:35 
QuestionVisual Studio Setup Project, how to make sure files are overwritten. Pin
^mrc^17-Feb-09 23:41
^mrc^17-Feb-09 23:41 
AnswerRe: Visual Studio Setup Project, how to make sure files are overwritten. Pin
Mirko198018-Feb-09 0:02
Mirko198018-Feb-09 0:02 
QuestionHow to set user-defined-type as Oracle SP input parameter in .NET Pin
AnilJayanti17-Feb-09 23:19
AnilJayanti17-Feb-09 23:19 
AnswerRe: How to set user-defined-type as Oracle SP input parameter in .NET Pin
ABitSmart18-Feb-09 0:46
ABitSmart18-Feb-09 0:46 
AnswerHow to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
AnilJayanti18-Feb-09 22:09
AnilJayanti18-Feb-09 22:09 
Hi,

i givng my code below.

I created two types for input and output parameter for a functions.

type get1 as object(deptno number(5))NOT FINAL;

TYPE GET2 AS OBJECT(DNAME VARCHAR2(14),LOC VARCHAR2(13))NOT FINAL;

///Function code :

function getdata(id in get1,data out get2)
return varchar2 is retval varchar(10); begin
select get2(dname,loc) into data from dept where deptno = get1.deptno;
retval := 'Result'; return retval; end;

///My .net code :

OracleConnection con = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.2.3)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORACLE)));User Id=scott;Password=tiger");

OracleCommand cmd = new OracleCommand("getdata", con);
cmd.CommandType = CommandType.StoredProcedure;

GET1 objget1 = new GET1();
GET2 objget2 = new GET2();

objget1.DEPTNO = 10;
GET2[] get22 = null;


OracleParameter outparam = new OracleParameter();
outparam.OracleDbType = OracleDbType.Object;
outparam.Direction = ParameterDirection.Output;
outparam.ParameterName = "data";
outparam.UdtTypeName = "GET2";
outparam.Value = objget2;


OracleParameter inparam = new OracleParameter();
inparam.OracleDbType = OracleDbType.Object;
inparam.Direction = ParameterDirection.Input;
inparam.ParameterName = "id";
inparam.UdtTypeName = "GET1";
inparam.Value = 10;

con.Open();
cmd.ExecuteNonQuery();

when i'm executing the below error is coming.

"ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments in call to 'GET_DATA_NEW'\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"

Pls help me.

modified on Tuesday, February 24, 2009 1:59 AM

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.