syntax variable question

From: orcl <orcl@xxxxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 18 Apr 2006 22:15:09 -0400

Hi, Im trying to get a variable passed , something is obviously wrong as every combination I've tried failed. Any suggestions for this simple syntax ?

set serveroutput on DECLARE ranon varchar2(14); BEGIN select to_char(sysdate, 'YYYYMMDDHH24MISS')INTO ranon from dual; execute immediate 'ALTER DATABASE backup CONTROLFILE to trace as '||ranon||'ctl'; -- DBMS_OUTPUT.PUT_LINE(ranon); END; /

sorry I dont post much, I lurk ;-)

thanks!
bob
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: syntax variable question
From: Domingo Diaz Saenz

Re: syntax variable question
From: Maxim Demenko

syntax variable question

Other related posts: