Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query in a Stored Procedure
Search the newsgroup. This question is asked almost daily. Have you
attempted to even read the manual? Look up ref cursor.
Jim
"Roman Sochan" <rsochan_at_removeme.ix.netcom.com> wrote in message
news:9mlchf$8qh$1_at_slb2.atl.mindspring.net...
> I'm new to Oracle stored procedures (my experience is with MS SQL Server
> stored procedures) and I can't find a way to store a SELECT sql statement
> that will return the result of a query.
>
> In SQL Server, it's okay to have a stored procedure in the form:
>
> CREATE PROCEDURE qryGetDirections
> @JobNum as varchar(20)
> As
> SELECT job, directions_desc
> FROM tblDirections
> WHERE job = @JobNum
>
> When it is run, it simply returns a different result set based on the
value
> of JobNum. In Oracle, a similar procedure would give me an error saying
> that I'm missing an INTO clause.
>
> How would I convert the above into PL/SQL and store it as a procedure, or
am
> I not able to store queries in an Oracle stored procedure?
>
>
Received on Thu Aug 30 2001 - 07:49:13 CDT