473,695 Members | 2,082 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PLS-00306: wrong number or types of arguments in call

Hi :

I am using Asp.Net, C#, Oracle .

I am trying to execute this Stored Procedure, and it gives me an error
"Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or
types of arguments in call to 'GET_CITY_DATA' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored "

Thanks in Advance
Zahir
Jul 21 '05 #1
2 13260
Pial <zi****@gmail.c om> wrote:
I am using Asp.Net, C#, Oracle .

I am trying to execute this Stored Procedure, and it gives me an error
"Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or
types of arguments in call to 'GET_CITY_DATA' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored "


Well, the error message seems pretty clear - you're either passing in
the wrong number of arguments, or the types are wrong.

There's nothing more that can really be said without you posting the
code you're using to call it, and the declaration of the stored proc.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Jul 21 '05 #2
Are you passing a VARCHAR2 as one of the parameters? When creating the
OracleParameter object, try setting the Size property to 8000 -
regardless of how large the parameter is actually defined in the stored
procedure.

Pial wrote:
Hi :

I am using Asp.Net, C#, Oracle .

I am trying to execute this Stored Procedure, and it gives me an error
"Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or
types of arguments in call to 'GET_CITY_DATA' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored "

Thanks in Advance
Zahir

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3901
by: Michael Hogan | last post by:
I want to pars a playlist file for three different varibles, so I can save them as mp3 files. I am using: strTEMPURL = GetUrlSource(Text1.Text) to put the entire .pls file into a strTEMPURL varible. I want to grab .pls files from shoutcast and break them into varibles. ----------------Begin winamp.pls file-------------------
0
1778
by: Rama krishna | last post by:
Hi All: I got the same problem what u got. Could u pls explain me hoe can i proceed. I saw some sites on this issue, which actually not worked with me. Iam using System.Directoryservices dll in my .aspx page. And iam adding refrence through the VS.NET and compling, working fine. But the same file i copied in the server (say some other machine which got only .NET Framework installed), so when iam trying to compile, iam getting the same...
1
13945
by: windos | last post by:
Guys, I'm newbie here and tryin to create a simple procedure : ---- CREATE OR REPLACE PROCEDURE update_status IS CURSOR cekstat is select b.CREATOR_PROC_INST_ID, b.MANAGED_FILE_ID, d.JOB_STATUS from other.rejprocesslog a,
1
2279
by: manish | last post by:
Hi, I am a fresher in the programming field i.e although I have done programming at the basic level but at professional level I am very new and I am facing many problems. These probllems are not taughtand I am not getting any Refrences to cope with them. ********Setting in VC++ 6.0 I don'know to apply setting for various/different projects. I am not getting basics out of it .Can u pls tell me how to make a good understanding of...
3
5068
by: bangaw | last post by:
i'm currently using c++ on windowsXP, unistd.h doesnt work for windows what other substitute for it could i use to replace it Pls. Help me Pls pls the code goes as follows #include <stdio.h> #include <unistd.h> #include <pthread.h>
0
1544
by: naheed javaid | last post by:
I m student and doing my final project. My project is related to screen capturing. my project captures screen and save the captured screen as bitmaps in a folder. while the screen recording audio is also captured.i hve saved the captured audio as wav file. i hve created avi form bitmaps only but i m not finding way how to add wav file to avi video. i hve searched alot but not finding help. if any body hve answer of my problem then pls reply...
0
2103
by: sathyakvani | last post by:
hi al i wrote a code (LOgin form) that checks the user id and if it exists validates the password but this is not all validating and simply displaying user does not exist i am sending the code pls check and fix it pls its urgent using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing;
17
4006
by: Riaaaa | last post by:
Pls check my code for the stored procedure which i created for the companydetails including companyid P.K. Not Null int(4), companyname Not Null varchar (20), address varchar(30) where companyid is the primary key and it should be autogenerate.
1
1463
by: vbsoft | last post by:
Hello My Name is Mike Am from Nigeria a student of computer Science, Pls i want your You to help in Using VISUAL BASIC 6.0 AND MS SQL SERVER AS DATABASE AS A CLIENT SERVER SIDE pLS: I WANT A DEMOSTRATION FORMS THAT WILL EXPLAIN HOW TO DESIGN THE DATABASE. AFTER THAT,
0
1530
by: sonuindia88 | last post by:
Some common confusions .I am reading Ritchie and Deitel and practising questions from Yashwant Kanetkar...Here are some of the confusions i am having..your help is required.... Q1) #include<stdio.h> int main() { printf("%d \n",-5%-4);
0
8638
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8578
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9120
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
7668
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6494
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3013
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2278
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1979
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.