I create a simple PL/SQL procedure to update some rows in Oracle 9i. The procedure was working through either SQLPLUS or TOAD. However, I used Informatica to call this procedure. It return the error message like these: " Backtrace message as the stack is unwounded by unhandled exceptions", "ORA-06512 line 8 and ORA06512 column 2","non-numeric character was found where a numberic was expected". Please help me on the syntax of this procedure. Is it missing something or Does it not connect to right schema? Thanks in advance.
Here is the coding:
CREATE OR REPLACE PROCEDURE F_MONTH_UPD
V_FISCAL_MONTH NUMBER (2);
SET FISCAL_MONTH = V_FISCAL_MONTH
WHERE MODIFICATION_DATE BETWEEN '1-DEC-2002' AND '31-DEC-2002';