Home » SQL & PL/SQL » SQL & PL/SQL » Getting error while compiling the procedure
Getting error while compiling the procedure [message #186513] Tue, 08 August 2006 05:11 Go to next message
Manish_VDF
Messages: 1
Registered: August 2006
Junior Member
Hi ,
I am getting the error while compiling the this procedure.
this giving error at line "WHERE CURRENT OF p_header_rec;"and error is shown is "PLS-00413: identifier in CURRENT OF clause is not a cursor name".

I will be appreciate you to solve my problem.

Thanks in advance

Manish
Re: Getting error while compiling the procedure [message #186520 is a reply to message #186513] Tue, 08 August 2006 05:33 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
WHERE CURRENT OF is used inside a cursor loop to allow you to update the current record that the cursor is pointing to.

You cannot use it as you are, to refer to a Rowtype passed into a procedure as a parameter.
Re: Getting error while compiling the procedure [message #186521 is a reply to message #186513] Tue, 08 August 2006 05:34 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll have to modify the WHERE clause; use of the WHERE CURRENT OF is invalid here as you'd need to use cursor name.

Therefore, this UPDATE statement should be something like
UPDATE TIB_CUS_MTL_TXNS_IFACE t SET 
  TRANSACTION_INTERFACE_ID = v_id, 
...
WHERE t.id = p_header_rec.id
  AND t.some_other_column = p_header_rec.some_other_column
...
Previous Topic: Response of the Select statement is extreme slow!!
Next Topic: query
Goto Forum:
  


Current Time: Thu Dec 08 18:43:39 CST 2016

Total time taken to generate the page: 0.06560 seconds