why this select is not work ?

[hany.sale72005]

this code is working local but when i put in server get error

 

 

 

select * from (WITH

   T

AS

(

SELECT

     REF,

     data

   FROM

      REPORT where style IN (select column_value from table(BEH_TEST(188,2)))

      UNION 

select 'basicBehconstant' ref ,to_char(RTRIM(TRANSLATE(column_value,'01234567zxcvbnmasdfghjklqwertyuiopZXCVBNMLKJHGFDSAQWERTYUIOP89/!@#$%^&*()',' '),' ')) data  FROM TABLE( beh_test(188,4) )

union

select 'sec_dic' ref, data from REPORT where ref='secondry_describ' and style=(select  column_value FROM TABLE( beh_test(188,3) ))

union

select 'other_third_describ' ref, data from REPORT where ref='other_describ' and style=(select  column_value FROM TABLE( beh_test( 188 ,5) ))

union

select 'other_four_describ' ref, data from REPORT where ref='other_describ' and style=(select  column_value FROM TABLE( beh_test(188,6) ))

union

select  ' point' ref  , TO_CHAR(round (to_number(RTRIM(TRANSLATE(column_value,' ض ص ث ق ف غ ع ه خ  z x c v b n m l k j h g f dZXVCBNMASDFGHJKLPOUYTREWQi s a q w e r t y u I o p ح ج د ش س ي ب ل ا ت ن م ك ط ئ ء ؤ ر لا ى ة و ز ظ ذ/!@-

#$-%^&*()',' '),' ') ),3 )) data FROM TABLE( beh_test(188,4) )

)

 

SELECT

   *

FROM

   T

PIVOT

(

 max( data)

   FOR

      (REF)

   IN

      ('point','basic_describ','secondry_describ','other_describ','basicBehconstant','basicbeh1','basicbeh2','basic_style')

))

 

 

 

 

Error: Unknown column name : 'point'

 

[hozawa]

>select  ' point' ref

You have a space here.

[hany.sale72005]

this select I used it on IReport when call this report on local machine is working good but it not work if we but on out server