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
tixy
Messages: 1
Registered: October 2012
Junior Member
Hi,
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 48 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: 58913
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.

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


Current Time: Thu Aug 28 00:36:37 CDT 2014

Total time taken to generate the page: 0.08214 seconds