ORA-00904 while running functions and procedures (IDE version 4.1.0.19)

Thanks for reply.

Everything is fine with the function. The most interesting thing is the same function works fine in previous version of IDE and not works in 4.1.0.19.

Function code:

create or replace PROCEDURE "P_VISITOR_OPERATIONS"

  (

    operation                           NUMBER,   

    id_in                               NUMBER,

    card_number_in                      NUMBER,

    surname_in                          VARCHAR2,

    name_in                             VARCHAR2,

    patronymic_in                       VARCHAR2,

    error_code                          OUT NUMBER,   

    error_message                       OUT NOCOPY VARCHAR2   

  ) AS

      is_exist      NUMBER;       

BEGIN

    error_code := 0;

    error_message := '';

    CASE operation

          WHEN 1 THEN --inserting new object       

                SELECT COUNT (*) INTO is_exist FROM keeper.visitor WHERE card_number = card_number_in;               

                IF is_exist = 0 THEN

                      INSERT INTO keeper.visitor ( id, card_number, surname, name, patronymic, work_schedule_id, break_schedule_id ) VALUES ( keeper.sq_visitor.nextval, card_number_in, surname_in, name_in, patronymic_in, 6, 7 );

                END IF;

          WHEN 3 THEN --deleting object

                DELETE FROM keeper.absence WHERE visitor_id = id_in;

                DELETE FROM keeper.event_history WHERE visitor_id = id_in;

                DELETE FROM keeper.event WHERE visitor_id = id_in;

                DELETE FROM keeper.visitor_structure WHERE visitor_id = id_in;

                DELETE FROM keeper.temporary_visitor WHERE visitor_id = id_in;

                DELETE FROM keeper.visitor_synchronization WHERE db_id = id_in;

                DELETE FROM keeper.visitor_synchronization_2 WHERE db_id = id_in;

                DELETE FROM keeper.md_group_visitor_position WHERE visitor_id = id_in;

                DELETE FROM keeper.visitor_name_cases WHERE visitor_id = id_in;

                DELETE FROM keeper.timekeeper_notification WHERE visitor_id = id_in;

                DELETE FROM keeper.project_manager_notification WHERE visitor_id = id_in;

                DELETE FROM keeper.project_manager_notification_b WHERE visitor_id = id_in;

                DELETE FROM keeper.temporary_visitor WHERE visitor_id = id_in;

                DELETE FROM keeper.temporary_visitor WHERE replaceable_visitor_id = id_in;

                DELETE FROM keeper.visitor WHERE id = id_in;                                                                                                                                                

    END CASE;

    EXCEPTION

        WHEN OTHERS THEN

            error_code := SQLCODE;

            error_message := SQLERRM;

END P_VISITOR_OPERATIONS;

Error screenshot

Which table you are interested? There are 15+ tables in keeper schema.

Yes sure, anonymous block works fine! Error occurs only if clicking on green arrow in editor.

The same result on this function:

create or replace FUNCTION f_is_admin

(

      user_name_in      IN    VARCHAR2

)

RETURN NUMBER

IS  

BEGIN

      IF INSTR ( keeper.global_constants.desktop_directory_admin, user_name_in ) > 0 THEN

            RETURN 1;

      ELSE

            RETURN 0;

      END IF;

      EXCEPTION

            WHEN OTHERS THEN

                  RETURN 0;

END;

I don't have a such menu in my IDE.

Database version:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod

PL/SQL Release 10.2.0.1.0 – Production

“CORE 10.2.0.1.0 Production”

TNS for 32-bit Windows: Version 10.2.0.1.0 – Production

NLSRTL Version 10.2.0.1.0 – Production