Print Thread
Stored procedures
#2098 06/05/01 07:35 PM
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
M
mwlang Offline OP
Member
OP Offline
Member
M
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
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.

Re: Stored procedures
#2099 06/06/01 11:34 AM
Joined: May 2001
Posts: 53
Enschede, The Netherlands
F
Member
Offline
Member
F
Joined: May 2001
Posts: 53
Enschede, The Netherlands
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


Frans
Re: Stored procedures
#2100 06/06/01 02:58 PM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
See this FAQ topic .

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


Marco Kalter
Allround Automations
Re: Stored procedures
#2101 06/06/01 07:45 PM
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
M
mwlang Offline OP
Member
OP Offline
Member
M
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
Thanks, that explains it. It would be nice to see this as an addendum to the TOraclePackage documentation in the on-line help.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.056s Queries: 12 (0.037s) Memory: 2.5076 MB (Peak: 3.0423 MB) Data Comp: Off Server Time: 2024-06-02 20:53:11 UTC
Valid HTML 5 and Valid CSS