Diego Lima

Diego Lima

  • NA
  • 2
  • 3.8k

Buffer PL / SQL (ORACLE) with C #

May 15 2012 3:04 PM
Good afternoon everyone!

I have a script in PL / SQL that generates an HTML report. But when my project run this script, the output ison the FTP server. In this script I have an option, whichis valid if it falls on a piece of code is as follows:

ELSE       

:buffer := V_BUFFER_TABLE;    

END IF;

That is, this part of the command causes a buffer to bedone, so extracting the report in the folder in which I determine in my project. But I do not know what would be this: buffer.

I have a VB6 project that uses the PL / SQL script for generating reports, and a part of his source believethat this "buffer" which is as follows:

OraDatabase.Parameters.Remove "buffer"

OraDatabase.Parameters.AddTable "buffer", ORAPARM_OUTPUT, ORATYPE_VARCHAR2, 20000, 1500

Set BufferArray = OraDatabase.Parameters.Item("buffer")

I wonder if anyone knows how to do this "feature" of the Oracle in C # for this address: buffer, this PL / SQL script.



Thank you guys!