Recent content by Tinti

Hi Marco thx for the very fast response. Have a nice day

Hello I try to write a file in a fixed length structure using pl/sql command window. Following the script: clear SET LINESIZE 384 SET COLWIDTH 0 SET PAGESIZE 0 SET FEEDBACK OFF SET TERMOUT OFF SET TRIMSPOOL OFF SET TRIMOUT OFF SET ECHO OFF SET SQLBLANKLINES ON SPOOL C:\TEMP\MyFile.csv...

Marco, thanks for the fast reply. What I want is following: Header => DATE_PER ID_Nbr X7777 - Value of Revenues Row001 => 05.05.10 147112 5282.15 Row002 => 05.05.10 012345 185.87 Row003 => ............................ Row004 => ............................ The...

Hi I have a query which I start in a sql window. The column name I can define with "as" e.g. => select objekt_name as Valuetype from dual Now I like to give a more complex column name. The name will be generated with another query e.g. => select objekt_name as (select name from testtab...

The limit is in fact 255 and not 50 characters. Sorry. But if I start the query in a sql window I will prompted for an input parameter and there I can paste a large query (incl. line breaks). If I start the query from a command window and paste the same query in the prompt then the parameter...

Thank you!

Hello in a command window I try to start a sql script like following: @'C:\TEMP\test.sql' '&stmt' The &stmt prompt me for an input. In my case this input can be a large query. Unfortunately the prompt seems to access only 50 character. Is it possible to increase this size? Thank's for any...

Thanks for your reply. So I can stop to look for a bug in my code :D

Hello I've following code whenever oserror exit whenever sqlerror exit @c:/temp/file1.sql @c:/temp/file2.sql @c:/temp/file3.sql The Result of this is following: script 1 done Error reading file script 3 done file2.sql doesn't exist. Although file3.sql runs. How can I stop the chain, when...

Hi I've tried it with this already. That's the way I will do it. But one last question. The file begins with a blank line. Is there a way to write the output without the first blank line? Thanks and have a nice weekend Joerg

Is it possible to start a script (e.g. @C:\TEMP\RUN_PGM3.sql) directly from pl/sql begin .. .. start @C:\TEMP\RUN_PGM3.sql ????? .. .. end; Or is it possible to spool the DBMS_OUTPUT to a file (I don't get access to UTL_FILE)

Hello I've following Code: @C:\TEMP\RUN_PGM1.sql @C:\TEMP\RUN_PGM2.sql SET LINESIZE 0 SET COLWIDTH 0 SET PAGESIZE 0 SET FEEDBACK OFF SET TERMOUT OFF SET ECHO OFF SPOOL C:\TEMP\OUTPUT.txt PROMPT TITEL SELECT * FROM ADH_ABO_7076_RM_WERTE_T ; SPOOL OFF / @C:\TEMP\RUN_PGM3.sql...

Hi It works fine. Thanks a lot for the fast reply. Have a nice day

Hi I have to start several scripts in a command window. Each script should have as parameter the same timestamp ("curr_ts"). How do I have to declare "curr_ts" and how to fill it with the current timestamp...

Thanks for the fast reply. I've tried both versions. But the output is still the same. It seems that my "set statements" is ignored. SET LINESIZE 999 SET PAGESIZE 0 SET FEEDBACK OFF SET TERMOUT OFF SET TRIMSPOOL ON SET ECHO OFF SPOOL L:\FSD_7061\OE91100\FSD7061_DM_RPBS_OE91100_DYYYYMM.txt...