Stored procedures

[mwlang]

What is the DOA equivalent to the BDE TStoredProc component?

The closest I found was the TOraclePackage, but our DBA did not put any of our stored procs in a package so I have no idea how to utilize this component with our database as-is.

 

[F.Hinlopen]

There is no real equivalent, but that doesn't matter at all. You can put an anonymous PL/SQL block in the SQL properties of both TOracleQuery and TOracleDataSet, including calls to stored procs. I tend to call stored procs from TOracleQuery instances, since generally speaking a stored proc is not really a dataset (but see the PkgApply demo for a counterexample, albeit in a package).

------------------
Frans

 

[Marco Kalter]

See this FAQ topic .

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

 

[mwlang]

Thanks, that explains it. It would be nice to see this as an addendum to the TOraclePackage documentation in the on-line help.