RE: SQL in PL/SQL

Hi,
.NET Oracle ODBC driver has this problem.  MSDN has a patch. Perhaps this is
related?
Earl

-----Original Message-----
From: Bill Lin [mailto:[email protected]]
Sent: Monday, January 27, 2003 4:05 PM
To: Oracle
Subject: [oracle] SQL in PL/SQL


I create a simple PL/SQL procedure to update some rows in Oracle 9i. The 
procedure is 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
IS
V_FISCAL_MONTH   NUMBER (2);

BEGIN

V_FISCAL_MONTH :=3;

UPDATE CAMSSTG.NDW_BOP_DETAIL_M_TEST
SET FISCAL_MONTH = V_FISCAL_MONTH
WHERE MODIFICATION_DATE BETWEEN '1-DEC-2002' AND '31-DEC-2002';

COMMIT;

END F_MONTH_UPD;
/
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].