TLDR: I'd like to edit a line of code inside of a function. Is editing the code and then running the CREATE OR REPLACE FUNCTION command basically the same thing as editing the function?
A user is receiving the following error message while running a report in Business Objects. Here is the error message:
ORA-06502: PL/SQL: numeric or value error: number precision too large :ORA-06512: at "GUI.PR_OMIT", line 30 :ORA-06512: at line 1 :-6502
So I opened up the function GUI.PR_OMIT in Oracle SQL Developer and I think I found the problem. There is a SELECT INTO statement that is trying to store a 4 digit number into a NUMBER(2) variable. I just want to change this to NUMBER(4). Can I just make the change and click the Run button? I am assuming this will 'CREATE OR REPLACE' the function - which in this case, it would be replacing it.