Accessing Oracle Database

[Arun]

Respected Sir,
In respect to input and output to Stored Procedure.
we can pass as indivitual parameter to the SP's for insert statements from
..net.
for reports we can get as ref cursor and able to display the values in the
form.

My Query..

1.What are all the input parameter that oracle SP will under stand?

2.Pasing object or Array as a parameter is it Possible ?.If so Can you help
us in finding a object in which we can group all the values and send to sp
as one object and the sp will split into the correspoding variable and
insert in the query.

3. Will the performance will reduce when we pass as individual parameter.?

-Regards
Arun

 

[Kevin Yu [MSFT]]

Hi Arun,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get some information on
Oracle parameters. If there is any misunderstanding, please feel free to
let me know.

1. Here is a list of all the types that an OracleParameter object can be.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdataoracleclientoracletypeclasstopic.asp

2. We can pass an char array or byte array to the parameter as value,
however, it has to match for corresponding types in Oracle database. We
cannot pass all the values as one object to the sp and let sp parse them.

3. We cannot pass all the values as single parameter, so we cannot tell the
performance issue.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Arun]

Hi All,
Thank for your information.
Can you gust clarify some more iisues..

1. Is is advisable to group all the values of different data type and send
to oracle Stored procedure
for insertion.

2. if Yes . can i try by sturcture .how about binay array .can you send a
sample.

3. If No. how would we pass the date?by .induvial parameter cause the coding
heavy..and maintanablity is high.

4. Can we implement XML for passing values to oracle from dotnet .
suggestion ?

Waiting with anticipation,
Arun.
Jaiganesh.R

 

[Kevin Yu [MSFT]]

Hi Arun,

1. It is not advisable to group all the value of different data type and
send to Oracle Stored procedure for insertion using ADO.NET.

3. You can use the OracleType.DateTime as the parameter type. I'm afraid
it's better to use individual parameter, because if we put all things
together, we have to seperate them from an Oralcle sp.

4. I'm not quite familiar with Oracle Xml. If it accepts xml string as
parameter, you can try to parse the xml inside the sp.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Guest]

Any luck on this Arun!
I am trying to send an XML from C# application.

What parameter type I should use for this.

XML can be send as an input parameter to SQL Server SP,
where we can use OpenXML.

Is there anything similar to OpenXML in Oracle to use the Input XML?