problem creating a view

From: thomas <t.beetz_at_web.de>
Date: 26 Aug 2004 09:12:14 -0700
Message-ID: <ffedb94d.0408260812.4a67b22a@posting.google.com>

hallo

package nms.pa_nms_tools is valid

CREATE OR REPLACE FORCE VIEW NMS.V_BAKOM
(S_N, CA, INFO, AG, TT,

 AH, AE, X, Y, X_P,
 Y_P, ASL, PR, DU, S_ID)
AS
(

SELECT SUBSTR(site_id,1,7) ,CARRIER,

nms.Pa_Nms_Tools.FU_BA(site_id,sector)as  INFO,
nms.Pa_Nms_Tools.FU_GET_AGL AS AGL,
nms.Pa_Nms_Tools.FU_GET_TLT AS TLT,
nms.Pa_Nms_Tools.FU_GET_ATH AS AZ,
nms.Pa_Nms_Tools.FU_GET_ADR AS AD,
nms.Pa_Nms_Tools.FU_GET_HW AS X_N,
nms.Pa_Nms_Tools.FU_GET_RW AS Y_N,
nms.Pa_Nms_Tools.FU_GET_P_HW AS X_P,
nms.Pa_Nms_Tools.FU_GET_P_RW AS Y_P,
nms.Pa_Nms_Tools.FU_GET_ASL AS ASL,
nms.Pa_Nms_Tools.FU_GET_PR AS PR,
nms.Pa_Nms_Tools.FU_GET_U_D AS D_U,
nms.Pa_Nms_Tools.FU_GET_S_ID AS SO_ID

  FROM x.u_c_at_dbl_p x_ca
);

i got an ora 4063 error. The following select works fine

SELECT SUBSTR(site_id,1,7) ,CARRIER,

nms.Pa_Nms_Tools.FU_BA(site_id,sector)as  INFO,
nms.Pa_Nms_Tools.FU_GET_AGL AS AGL,
nms.Pa_Nms_Tools.FU_GET_TLT AS TLT,
nms.Pa_Nms_Tools.FU_GET_ATH AS AZ,
nms.Pa_Nms_Tools.FU_GET_ADR AS AD,
nms.Pa_Nms_Tools.FU_GET_HW AS X_N,
nms.Pa_Nms_Tools.FU_GET_RW AS Y_N,
nms.Pa_Nms_Tools.FU_GET_P_HW AS X_P,
nms.Pa_Nms_Tools.FU_GET_P_RW AS Y_P,
nms.Pa_Nms_Tools.FU_GET_ASL AS ASL,
nms.Pa_Nms_Tools.FU_GET_PR AS PR,
nms.Pa_Nms_Tools.FU_GET_U_D AS D_U,
nms.Pa_Nms_Tools.FU_GET_S_ID AS SO_ID

  FROM x.u_c_at_dbl_p

best regards
thomas beetz Received on Thu Aug 26 2004 - 11:12:14 CDT