The beautifier caused an error ...

[orca777]

PLSQL/DEV 5.1.4, NT 4.0, Oracle 9.0.1.4
Error box appeared ...

SELECT
	AA.*
        ,CASE
--
-- Bei Non-Trades werden ST_SETTL_AMNT_BCY und ST_SETTL_AMNT_TCY direkt von TRANOUT gelesen
--
--        	WHEN ST_BUSINESS_TYPE = 'NT' THEN
--        		CALC_PRINC_AMNT_TCY + ST_ACCR_INT_TCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * ST_FEES_TCY
        	WHEN ST_BUSINESS_TYPE IN ('CS','TR','NT') THEN
        		TR_SETTL_AMNT_TCY
   		-------------
   		-- EX, RE, SP, BT
   		-------------
        	ELSE 0
       	 END						ST_SETTL_AMNT_TCY
	,CASE
--
-- Bei Non-Trades werden ST_SETTL_AMNT_BCY und ST_SETTL_AMNT_TCY direkt von TRANOUT gelesen
--
--   		WHEN ST_BUSINESS_TYPE = 'NT' THEN
--        		CALC_PRINC_AMNT_BCY + ST_ACCR_INT_BCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * ST_FEES_BCY
        	WHEN ST_BUSINESS_TYPE IN ('CS','TR','NT') THEN
        		TR_SETTL_AMNT_BCY
   		-------------
   		-- EX, RE, SP
   		-------------
   		ELSE 0
 	 END 						ST_SETTL_AMNT_BCY
--
--        ,CASE
--        	WHEN ST_BUSINESS_TYPE IN ('EX','CS','RE','TR','NT') THEN
--        		--CALC_PRINC_AMNT_BCY + nvl(CALC_ACCR_INT_TCY,0) / ST_FX_RATE_TCY
--			CALC_PRINC_AMNT_BCY + ST_ACCR_INT_BCY
--        	-- BT, SP
--        	ELSE 0
--       	 END						ST_CAP_FLOW_BCY
--
--	neue Berechnung CAP_FLOW
--
       ,CASE
	       WHEN ST_WKN = NVL(ST_INT_REF,' ') THEN
		  CASE
		       WHEN DPT_TRACK_Y = 'B' THEN
			    TR_SETTL_AMNT_BCY
		       WHEN DPT_TRACK_Y = 'M' THEN
			    CALC_MARKET_PRINC_AMNT_BCY + ST_ACCR_INT_BCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * ST_FEES_BCY
		       WHEN DPT_TRACK_Y = 'G' THEN
		            CALC_MARKET_PRINC_AMNT_BCY + ST_ACCR_INT_BCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * (ST_FEES_BCY - (ST_KEST_BCY + ST_ZAST_BCY))
		       WHEN DPT_TRACK_Y = 'N' THEN
			   0
                       WHEN DPT_TRACK_Y IS NULL THEN
                            TR_SETTL_AMNT_BCY
		  END
	       WHEN ST_WKN != NVL(ST_INT_REF,' ') THEN
		  CASE
		       WHEN DPT_TRACK_N = 'B' THEN
			    TR_SETTL_AMNT_BCY
		       WHEN DPT_TRACK_N = 'M' THEN
			    CALC_MARKET_PRINC_AMNT_BCY + ST_ACCR_INT_BCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * ST_FEES_BCY
		       WHEN DPT_TRACK_N = 'G' THEN
		            CALC_MARKET_PRINC_AMNT_BCY + ST_ACCR_INT_BCY - ST_SIGN_AMNT * ST_SIGN_REVERSAL * (ST_FEES_BCY - (ST_KEST_BCY + ST_ZAST_BCY))
		       WHEN DPT_TRACK_N = 'N' THEN
			   0
                       WHEN DPT_TRACK_N IS NULL THEN
                            TR_SETTL_AMNT_BCY
		  END
	END							ST_CAP_FLOW_BCY
       ,CASE
		WHEN ST_WKN = NVL(ST_INT_REF,' ') THEN
			DPT_PERF_FLAG_Y
		ELSE
			DPT_PERF_FLAG_N
	END							ST_PERF_FLAG
--
--
--
       ,NVL2(ST_SETTL_DATE,0,1)                         ST_EXC_SETTL_DATE
       ,NVL2(ST_TRADE_DATE,0,1)				ST_EXC_TRADE_DATE
FROM
        V2_SEC_TRAN_XX	AA

Regards
Karl

 

[Marco Kalter]

This does indeed fail. We'll fix it.

 

[Stefan GRECU]

Getting the same with:


DECLARE
FUNCTION get_new_id RETURN VARCHAR2 IS
res VARCHAR2(12);
BEGIN

SELECT to_char(myseq .NEXTVAL, '000000000000') INTO res FROM dual;
RETURN res;

END;

BEGIN
dbms_output.put_line(get_new_id);
END;


Shtefan.

 

[Stefan GRECU]

Forgot to say:
Version 6.0.2.880 (MBCS)
07.19058 - Unlimited user license
Windows XP version 6,0 (build 2600) Service Pack 1

 

[Marco Kalter]

This is caused by the space between myseq and .NEXTVAL. This is fixed for 6.0.3.

 

[Stefan GRECU]

Right ...

TX,
Stefan