Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> cannot execute my script file !!

cannot execute my script file !!

From: deb <dnanda_at_netcom.ca>
Date: Mon, 26 Apr 1999 21:38:33 -0400
Message-ID: <AS8V2.25384$134.287899@tor-nn1.netcom.ca>


The script file goes like this :-

set echo off verify off head off feed off accept product_no varchar2 -
prompt 'what name would you like..'
variable q_name varchar2(30)
execute :q_name :=q_prod('&product_no') set head on feed on
print q_name
set echo on verify on

        And the function that has been called is as follows - create or replace function q_prod
(v_id varchar2) return varchar2 is
v_name varchar2(30);
begin
select name into v_name from sales where s_no=v_id; return(v_name);
end q_prod;

thanks Received on Mon Apr 26 1999 - 20:38:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US