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 -> Pass a PL/SQL variable into SQL DEFINE

Pass a PL/SQL variable into SQL DEFINE

From: Jeff Y. Y. <yuanjeff_at_yahoo.com>
Date: 30 Apr 2002 17:14:13 -0700
Message-ID: <a2bc9497.0204301614.63b73608@posting.google.com>


I want to pass variable wkday from a PL/SQL function into a SQL variavle, but can not make it work. I need the result 'dir = h:\Backup\WED'. Do you know how to do it? Thanks a lot.



variable wkday varchar2(3)
exec :wkday := weekday;
print wkday

define kk = :wkday

define dir = 'h:\Backup\&kk'
prompt &dir



The function is
create or replace FUNCTION weekday return varchar2 IS wkday varchar2(3);
BEGIN
  select to_char(sysdate, 'DY') into wkday from dual; return wkday;
END; Received on Tue Apr 30 2002 - 19:14:13 CDT

Original text of this message

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