Re: problem creating a view

t.beetz_at_web.de (thomas) wrote:

>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

What 'string' is identified as the problem.. The error message should have it..

ORA-04063 'string' has errors

Cause: Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view's defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types.

Action: Fix the errors and/or create referenced objects as necessary.