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 26 times)

Report message to a moderator

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: 54127
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 06:26:22 CDT 2013

Total time taken to generate the page: 0.30700 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.