Home » SQL & PL/SQL » SQL & PL/SQL » ORA:01732
ORA:01732 [message #346442] Mon, 08 September 2008 10:27 Go to next message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

When i am compling this... getting this error...

Error: PL/SQL: ORA-01732: data manipulation operation not legal on this view
Line: 95
Text: INSERT INTO ABC.ABC_TRANSACTIONS_1 (

Error: PL/SQL: SQL Statement ignored
Line: 95
Text: INSERT INTO ABC.ABC_TRANSACTIONS_1 (

This is not a view.. I am inserting value to a table..

CREATE OR REPLACE PACKAGE BODY ABC_financials AS
AS 
PROCEDURE Infintran(
    p_loan_id                   IN NUMBER,
    p_transaction_id            IN NUMBER,
    p_finc_tran_status_id       IN NUMBER,
    p_tran_type                 IN CHAR,
    p_check_number              IN VARCHAR2
    p_tran_date                 IN DATE,
    p_tran_class                IN CHAR,
    p_tran_amount               IN NUMBER
BEGIN 
    INSERT INTO ABC.ABC_TRANSACTIONS_1 (
    p_loan_id                   ,
    p_transaction_id            ,
    p_finc_tran_status_id       ,
    p_tran_type                 ,
    p_check_number              ,
    p_tran_date                 ,
    p_tran_class                ,
    p_tran_amount               
         )        
    VALUES     (
    p_loan_id                   ,
    p_transaction_id            ,
    p_finc_tran_status_id       ,
    p_tran_type                 ,
    p_check_number              ,
    p_tran_date                 ,
    p_tran_class                ,
    p_tran_amount               
 );
END Infintran;





I am not looking for detail answer, Any small hint would be appreciated
Re: ORA:01732 [message #346443 is a reply to message #346442] Mon, 08 September 2008 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

> Any small hint would be appreciated
Look at line 95
Re: ORA:01732 [message #346448 is a reply to message #346442] Mon, 08 September 2008 10:40 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Quote:

ORA-01732: data manipulation operation not legal on this view
Cause: An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions or was derived from more than one table. If a join operation was used to create the view or the view contains virtual columns derived from functions or expressions, then the view may only be queried.
Action: UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.




This was the first hit in google Smile
Re: ORA:01732 [message #346449 is a reply to message #346443] Mon, 08 September 2008 10:41 Go to previous message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

Thanks for your hint.. I found the problem...

Appreciate your valuable time...
Previous Topic: Merge with extra condition
Next Topic: Database Triggers (merged)
Goto Forum:
  


Current Time: Sun Dec 04 21:00:53 CST 2016

Total time taken to generate the page: 0.06988 seconds