Click here to Skip to main content
15,902,114 members
Home / Discussions / C#
   

C#

 
AnswerRe: Retrieve Images from Databse Pin
Mycroft Holmes23-Feb-09 21:53
professionalMycroft Holmes23-Feb-09 21:53 
QuestionPipes! and they aint for smoke'n Pin
Mel Feik23-Feb-09 21:16
Mel Feik23-Feb-09 21:16 
AnswerRe: Pipes! and they aint for smoke'n Pin
Rob Philpott23-Feb-09 22:07
Rob Philpott23-Feb-09 22:07 
GeneralRe: Pipes! and they aint for smoke'n Pin
Mel Feik24-Feb-09 5:59
Mel Feik24-Feb-09 5:59 
QuestionHow to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
AnilJayanti23-Feb-09 21:14
AnilJayanti23-Feb-09 21:14 
AnswerRe: How to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
Nagy Vilmos23-Feb-09 22:03
professionalNagy Vilmos23-Feb-09 22:03 
AnswerRe: How to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
ABitSmart23-Feb-09 22:07
ABitSmart23-Feb-09 22:07 
GeneralRe: How to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
AnilJayanti23-Feb-09 22:40
AnilJayanti23-Feb-09 22:40 
Ohh Sorry,

thnxs for reply me.

I forgot to paste that lines . Now i applied that applied then another errors is coming.


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;


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

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

objget1.DEPTNO = 10;
objget1.DEPTNOIsNull = false;
//GET2[] get22 = null;

OracleParameter retval = new OracleParameter();
retval.OracleDbType = OracleDbType.Varchar2;
retval.ParameterName = "retval";
retval.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(retval);

OracleParameter inparam = new OracleParameter();
inparam.OracleDbType = OracleDbType.Object;
inparam.Direction = ParameterDirection.Input;
inparam.ParameterName = "id";
inparam.UdtTypeName = "GET1";
inparam.Value = objget1;
cmd.Parameters.Add(inparam);

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

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


Error like

"ORA-03113: end-of-file on communication channel\nProcess ID: 0\nSession ID: 20 Serial number: 25".


pls help.
GeneralRe: How to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
ABitSmart23-Feb-09 22:57
ABitSmart23-Feb-09 22:57 
GeneralRe: How to use user-defined-type input and output parameters in Oracle Function using ODP.NET Pin
AnilJayanti23-Feb-09 23:07
AnilJayanti23-Feb-09 23:07 
QuestionHow to place dropdownlist in the header of the calender control Pin
P G Kishore23-Feb-09 21:11
P G Kishore23-Feb-09 21:11 
AnswerRe: How to place dropdownlist in the header of the calender control Pin
Deresen23-Feb-09 21:56
Deresen23-Feb-09 21:56 
AnswerRe: How to place dropdownlist in the header of the calender control Pin
Nagy Vilmos23-Feb-09 21:59
professionalNagy Vilmos23-Feb-09 21:59 
Questionenable vista syle application in c# Pin
Abdul Rahman Hamidy23-Feb-09 20:56
Abdul Rahman Hamidy23-Feb-09 20:56 
AnswerRe: enable vista syle application in c# Pin
Greg Chelstowski23-Feb-09 21:31
Greg Chelstowski23-Feb-09 21:31 
QuestionCalculate length of textBox for N number of characters Pin
kanchoette23-Feb-09 20:54
kanchoette23-Feb-09 20:54 
AnswerRe: Calculate length of textBox for N number of characters Pin
Mel Feik23-Feb-09 21:38
Mel Feik23-Feb-09 21:38 
AnswerRe: Calculate length of textBox for N number of characters Pin
Rob Philpott23-Feb-09 22:02
Rob Philpott23-Feb-09 22:02 
AnswerRe: Calculate length of textBox for N number of characters Pin
ABitSmart23-Feb-09 22:14
ABitSmart23-Feb-09 22:14 
GeneralRe: Calculate length of textBox for N number of characters Pin
kanchoette23-Feb-09 22:21
kanchoette23-Feb-09 22:21 
QuestionExporting Multiple Sheets in Excel Pin
venkateswaran0223-Feb-09 20:30
venkateswaran0223-Feb-09 20:30 
AnswerRe: Exporting Multiple Sheets in Excel Pin
Greg Chelstowski23-Feb-09 21:34
Greg Chelstowski23-Feb-09 21:34 
QuestionOverloading increment operator [modified] Pin
PIEBALDconsult23-Feb-09 20:27
mvePIEBALDconsult23-Feb-09 20:27 
AnswerRe: Overloading increment operator Pin
DaveyM6923-Feb-09 22:51
professionalDaveyM6923-Feb-09 22:51 
GeneralRe: Overloading increment operator Pin
PIEBALDconsult24-Feb-09 5:11
mvePIEBALDconsult24-Feb-09 5:11 

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.