PLSQLTable

[bobsimoneau]

I have a delphi TStringList with 61,000 lines, and want to transfer then to a oracle package where they can be put into a temp table. I have to pass the package.procedure the temp table name and a recordset (my Tstringlist). I can not seem to figure out how to use a PLSQLTable with DOA.

 

[Marco Kalter]

Have you read the 'PL/SQL Tables' section in the Help file or User's Guide? It contains a complete example.

If you are using version 3.4 you can also use the Package Wizard to create an easy-to-use class that encapsulates the functionality of your package, including the PL/SQL Table function. The TPLSQLTable class can be used by TCustomOraclePackage descendants generated by the Package Wizard.

------------------
Marco Kalter
Allround Automations

 

[bobsimoneau]

I have read the section of the manual several times, and have made several attempts.
Below is a sample of my last try.

Delphi Function

function TFilterObj.Populate_Temp_Table(pvs_string: string): string;
var
lvw_answer: word;
DOASP_filter: TOraclepackage;
qry: TOracleQuery;
lvs_temptable: string;
Table : Variant;

begin
//Insert value from previously populated string list
// Temp table was already created, its name is stored in
Table := VarArrayCreate([0,cvo_ParseList.Count -1], varVariant);
for lvi_cnt := 0 to cvo_ParseList.Count -1 do
Table[lvi_cnt] := trim(cvo_ParseList.strings[lvi_cnt]);
qry.DeclareVariable('pvs_temptable',otString);
qry.DeclareVariable('filter_value',otstring);
qry.DeclareVariable('pvt_values',otstring); //