Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> cannot execute my script file !!
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
![]() |
![]() |