473,324 Members | 2,214 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

created PL/SQL procedure and get error PLS-00306

I created the pl/sql procedure below and when i try to execute it gives me error
PLS-00306: wrong number or types of arguments in call to 'INST_TOTAL'

Any information would be appreciated;

Expand|Select|Wrap|Line Numbers
  1. SQL> CREATE OR REPLACE PROCEDURE inst_total(instnum number)
  2.   2     AS
  3.   3
  4.   4     CURSOR totalsect(inum number) IS
  5.   5     SELECT last_name, instructor_id, COUNT(section_id) as totsection
  6.   6        FROM instructor JOIN section USING(instructor_id)
  7.   7        where instructor_id=inum
  8.   8        GROUP BY last_name, instructor_id;
  9.   9
  10.  10  BEGIN
  11.  11     dbms_output.put_line(rpad('LName: ', 15)||rpad('Inst. ID: ', 9)||lpad('Total Sec.: ', 12));
  12.  12
  13.  13     FOR VROW in totalsect(instnum)
  14.  14     LOOP
  15.  15
  16.  16     dbms_output.put_line(rpad(vrow.last_name, 15)||rpad(vrow.instructor_id, 9)||lpad(vrow.totsection, 12));
  17.  17     END LOOP;
  18.  18  END;
  19.  19  /
  20.  
  21. Procedure created.
  22.  
  23. SQL> exec inst_total
  24. BEGIN inst_total; END;
  25.  
  26.       *
  27. ERROR at line 1:
  28. ORA-06550: line 1, column 7:
  29. PLS-00306: wrong number or types of arguments in call to 'INST_TOTAL'
  30. ORA-06550: line 1, column 7:
  31. PL/SQL: Statement ignored
May 9 '13 #1
1 1916
Rabbit
12,516 Expert Mod 8TB
You didn't pass an argument to your procedure that it was expecting.
May 9 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DM | last post by:
Get this error when I try to run any ASP.NET web app from Visual Studio on my Win2K PC. Anyone seen this before ? BC32400: Class 'CLSID_CorSymWriter' could not be created: System Error...
1
by: steven.cooper | last post by:
Does anyone know exactly what behaviour is exhibited when running a stored procedure and the log file fills up while the procedure is still running? I am seeing, through a created history table, a...
9
by: dtwilliams | last post by:
OK, i'm trying to do some error checking on stored procedures and am following the advise in Erland Sommarskog's 'Implementing Error Handling with Stored Procedures' document. Can anybody help...
5
by: Raquel | last post by:
Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP. I am new to stored procedures. The stored procedure code I am using is at:...
0
by: TRiaRii | last post by:
Hello I have inserted a java stored procedure using wizard, when I try to build it shows the next error: .... SGEDES2.PROC1 - Jar file created. SGEDES2.PROC1 - SQL0102N The string constant...
17
by: bikash_karan | last post by:
Hi Folks , I am few days old to the world of DB2 and right now i am stuck into a problem that seems to be getting difficult for me. Please have alook into this and provide me some help. Below...
1
by: Child | last post by:
Hi, I am getting the error: "Procedure or function spAddActivity has too many arguments specified. " on a stored procedure insert. I compared the number of parameters in the function and the SP...
3
by: Goog79 | last post by:
Hi everyone, first time here, so I'm sorry if this has been covered already ages ago. :( I am trying to learn T-SQL and Stored Procedures and bought the book on these topics by Djan...
1
by: AdamGr | last post by:
This must be a pretty newbie mistake, but I'm still flummoxed by it. I created a very simple procedure: create procedure deleteAll () begin delete from test1; delete from test2; end but...
2
by: Jeganath | last post by:
Hi, I have written a Stored Procedure. I'm getting the error as below. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). Can any one give me a solution...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.