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
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
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
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