Home » SQL & PL/SQL » SQL & PL/SQL » Error while using sql merge (Oracle 11gr2,windows 7)
Error while using sql merge [message #569414] Thu, 25 October 2012 13:57 Go to next message
Messages: 1
Registered: October 2012
Junior Member
I am getting an error while i was using merge statement.Please help.

error msg :
[Error] Execution (138: 16): ORA-06553: PLS-306: wrong number or types of arguments in call to 'V'
  • Attachment: merge.sql
    (Size: 4.12KB, Downloaded 84 times)
Re: Error while using sql merge [message #569416 is a reply to message #569414] Thu, 25 October 2012 14:04 Go to previous message
Michel Cadot
Messages: 64967
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far as I can see your query has 112 lines and so can't have an error in line 138.
So the error is elsewhere.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Previous Topic: Information on Package Contents
Next Topic: Sum and GroupBy
Goto Forum:

Current Time: Thu Jun 29 11:11:47 CDT 2017

Total time taken to generate the page: 0.11855 seconds