Re: SQL in PL/SQL

Dear Friend:

Thank yo so much for your input. I tried. It works. You are the guru.


> May hint is that it should be the date specified in the update statement.
Since the way you implicitly convert dates is defined by client setting in 
Oracle. It would be a muche better practice to always explicitly convert 
the dates in Oracle using the to_date function 

Ex. 
MODIFICATION_DATE BETWEEN to_date('1-DEC-2002','dd-mon-YYYY') AND to_date
('31-DEC-2002','dd-mon-YYYY')

Hope this helps

X

------------------------
 "Oracle" <[email protected]> wrote:
------------------------
	
>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].