BO and Oracle Stored Procedures

general discussion
1

I’m about to start work with Oracle Stored Procedure.

Has anyone else used them and if so what are you experiences.

Any hints and tips ?

Thanks in anticipation.

Neil

Neil Bain
EDS,
Royfold House,
Hill of Rubislaw,
Aberdeen,
AB15 6GZ.

Listserv Archives (BOB member since 2002-06-25)

2

In a message dated 98-07-09 11:09:09 EDT, you write:

I’m about to start work with Oracle Stored Procedure.

Has anyone else used them and if so what are you experiences.

Any hints and tips ?

Thanks in anticipation.

Neil

Neil:

Good news and bad news…

You can use Oracle Stored Functions to supplement the standard Oracle tool set. In fact, there is a paper on our web site that discusses that very idea. But Oracle Stored Procedures do not generate output, and therefore are not valid for use as a data provider. I suspect that is what you were intending to do.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)