Oracle10g :: Using Dbms_output.get_line?

Apr 13, 2011

I have some stored procedures to execute that use dbms_output.put_line() to put data into the output buffer.I know I need to use dbms_output.get_line(:line, :status) to retrieve that output.I'm using ystem.Data.OracleClient to avoid headaches with Oracle deployment.So what am I doing wrong with the code below?

Dim cmdSproc As OracleCommand = cnOracle.CreateCommand()
Dim strOracle As New OracleString()
Dim opaLine As New OracleParameter("lineOut", OracleType.VarChar, 255)

[code]....

View 1 Replies


ADVERTISEMENT

Sql - Retrieve Oracle DBMS_Output From A Application

Aug 4, 2010

I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code?

View 1 Replies

Not Getting Option Of Connecting Oracle10g

Jun 9, 2011

am an computer engineering student, & these days engaged in a project, the front end tool is vb.net 2008 & the back end tool is oracle10g... am using windows xp as OS.... am not getting option of connecting oracle10g.. i guess, oracle10g is properly installed in my system... then so am not able connect it...

View 1 Replies

Oracle10g - Optomizing Bulk Inserts Into Oracle

Feb 1, 2010

I am inserting a block of 5000 records at a time, one block right after the other. The commands are created in a seperate DLL and can call anyone of 4 different stored procedures. Is there a bulk insert method that might speed this up. Currrently it takes about 1.5 MS per record and would like to get this down to about .7 MS.

[Code]...

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved