Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Dope needs help with retrieving records from stored procedure
jerel_at_rockbaby.com (spawncamper) wrote in message news:<f2f4fe50.0406171212.49ae637c_at_posting.google.com>...
> I'm fairly new to Oracle, so I apologize in advance if this question
> makes you shake your head. However, I'm trying to create a stored
> procedure in Oracle 8i to return a value that would be called using
> SELECT EMPLOYEEID FROM EMPLOYEELASTNAME('JONES') where
> EMPLOYEELAASTNAME would be the name of the procedure and would
> obviously return the id.
>
> When I create a proc to do a select, I get a "an INTO clause is
> expected in this SELECT statement" error. Doing research on the
> internet has not been fruitful. Any assistance for would be greatly
> appreciated.
>
> Thanks,
>
> An Oracle Dope
Thanks to everyone for taking time from your day to give me assistance. Your help has provided me with direction and I'll be looking into your suggestions.
Thanks again. Received on Fri Jun 18 2004 - 09:55:06 CDT