I need to retrieve data from an oracle table using a pl/s开发者_如何学Cql stored procedure and odp.net. What is the standard way of doing this?PL/SQL has the ability to return sets of data using Ref C
TYPE point IS RECORD ( X NUMBER,-- The X co-ordinate of the point Y NUMBER-- The Y co-ordingate of the point
We are getting the following warning from Code Analysis in Visual Studio 2010 and I\'m wondering if this is a false positive that we can safely ignore or the code should be refactored to correctly dis
I开发者_C百科s there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects?
I am using the Oracle Data Provider. I am having trouble calling开发者_Python百科 a function that returns a record type defined as TABLE_NAME%ROWTYPE. How do you do this from C# ODP.net does not work
I have a table with a primary key consisting of two columns. I want to retrieve a set of rows based on two input arrays, each corresponding to one primary key column.
I have a window form application running in client machine. some clients are still using oracle92 client and didn\'t install opd.net in their machine. I have updated my oracle client as 10g, and my ap
Trying to insert a large audio file into an Oracle 10g database and keep getting this error: ORA-01460: unimplemented or unreasonable conversion requested
Sup guys, heres my view: CREATE OR REPLACE VIEW SISTEMA.VWTELA AS SELECT TEL_DLTELA AS Tela, TEL_DLDESCRICAO As Descricao,
When I try to execute a create procedure using ODP.NET I get back ORA-24344: success with compilation error.However, when I run the same statement in SQL Developer it compiles successfully.Does anyone