Re: Basic Proc Question

You don't need a insert into, but you do have to have an into clause as part of your select to tell it where to put the data (i.e. what variables).

HTH,
Geoffrey

In article <3a79a729$0$1510$7ea90a65_at_news.netdirect.net>,   "Brian Forster" <brian.forster_at_cnhiindiana.com> wrote:
> Hi All,
>
> I realize this is a very basic question, but I come from a SQL Server
> background and I am trying to grip the following difference between
 SQL Serv
> and Oracle.
>
> Basically I want to create a procedure that is nothing more than a
 select
> statement that accepts a parameter.
>
> Here is what I have:
>
> create procedure Daily_Ads
> (rep_no IN varchar2)
> as
> Begin
> Select adno,unet from ad where vnoflag = 'Y' and
 receiver =
> rep_no
> and prdate =
> to_char(to_date(Sysdate,'MM/DD/YYYY'),'MM/DD/YYYY');
> End;
>
> Then call it execute Daily_Ads('A23');
>
> The procedure is marked invalid because I don't have an insert into.
 I
> don't want one, I just want to return records. Can I do this?
>
> Please Help
>
> TIA
>
> Brian
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 13:41:41 CST