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

C#

 
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

QuestionHow to override Button Click EventArgs or use another ways to achieve it? Pin
mctramp16817-Feb-09 21:10
mctramp16817-Feb-09 21:10 
AnswerRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
dan!sh 17-Feb-09 21:33
professional dan!sh 17-Feb-09 21:33 
GeneralRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
mctramp16817-Feb-09 22:40
mctramp16817-Feb-09 22:40 
GeneralRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
Guffa17-Feb-09 23:19
Guffa17-Feb-09 23:19 
GeneralRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
dan!sh 18-Feb-09 2:10
professional dan!sh 18-Feb-09 2:10 
GeneralRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
mctramp16818-Feb-09 14:02
mctramp16818-Feb-09 14:02 
AnswerRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
Luc Pattyn18-Feb-09 2:54
sitebuilderLuc Pattyn18-Feb-09 2:54 
AnswerRe: How to override Button Click EventArgs or use another ways to achieve it? [modified] Pin
DaveyM6918-Feb-09 0:45
professionalDaveyM6918-Feb-09 0:45 
GeneralRe: How to override Button Click EventArgs or use another ways to achieve it? Pin
mctramp16818-Feb-09 15:00
mctramp16818-Feb-09 15:00 
Question.exe file creation Pin
aratireddy17-Feb-09 20:20
aratireddy17-Feb-09 20:20 
AnswerRe: .exe file creation Pin
N a v a n e e t h17-Feb-09 20:34
N a v a n e e t h17-Feb-09 20:34 
AnswerRe: .exe file creation Pin
Vimalsoft(Pty) Ltd17-Feb-09 21:46
professionalVimalsoft(Pty) Ltd17-Feb-09 21:46 
QuestionSQL Server, client-server connection Pin
MozhdehQeraati17-Feb-09 20:16
MozhdehQeraati17-Feb-09 20:16 
QuestionIIS Pin
MozhdehQeraati17-Feb-09 20:10
MozhdehQeraati17-Feb-09 20:10 
AnswerRe: IIS Pin
Vimalsoft(Pty) Ltd17-Feb-09 21:47
professionalVimalsoft(Pty) Ltd17-Feb-09 21:47 
QuestionFileStream write into file Pin
AndieDu17-Feb-09 19:35
AndieDu17-Feb-09 19:35 
AnswerRe: FileStream write into file Pin
N a v a n e e t h17-Feb-09 20:39
N a v a n e e t h17-Feb-09 20:39 

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.