Re: Stored procedures

On Wed, 11 Mar 1998 10:31:15 -0600, "Doug Needham" <DNeedham_at_mccorp.com> wrote: Hi,

in contrary to MS-SQL-Server oracle hasn't stored procedures (SP) returning dynasets which was implemented in MS SQL 'cause Acces did it. To get similar behavior you've got to use Oracle Objects for OLE OO4O, which are shipped with oracle's client software. There's an VB-Version and a dll-version for C++. Using oracle ref cursor's you can implement SP's returning cursors (dynasets). With OO4O your app can easily make use of those SPs. Oracle ships also very good samples how to use OO4O in general and ref cursors in detail. It works fine and performance can be accepted.

>I have PO7 for Windows NT up and working, and the ODBC drivers
>installed. I think
>everything is working somewhat. I am trying to port a SQL Server 6.5
>database over to Oracle for testing, and I have this problem :
>This is a stored procedure in SQL Server, and when I try to move this to
>Oracle it fails. Questions.
>1) Can I do this in oracle? (return a set of data from a stored
>procedure)
>2) if so, how?
>3) if not why?
>CREATE PROCEDURE Allocated_Time_All_For_Date(CC IN varchar2, ID IN
>varchar2, TD IN varchar2)
>AS
>SELECT * from Allocated_Time WHERE
>company_code = CC AND
>employee_or_equipment_id = ID AND
>timesheet_date = TD
>ORDER BY rate_user_hours;
>Any assistance would be appreciated.
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de