Oracle Error Ora-06550
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload ora-06550 pls-00201 this page. Please enter a title. You can not post a blank ora-06550 pls-00103 message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application
Ora-06550 Line 1 Column 7
DevelopmentPL/SQL and SQL This discussion is archived 13 Replies Latest reply on Nov 2, 2012 3:33 PM by BluShadow ORA-06550: line1,column7: PLS-00306: wrong number or types of arguments 972054
Ora-06550 Pls-00306
Nov 2, 2012 2:20 PM Hello All, I am getting this error: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GETCURRENCYFROMSCENARIO' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Can anybody help me with this error that I am getting on VB.net: Any responses will be very helpful ORA-06550: line ora-06550 pls-00905 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GETCURRENCYFROMSCENARIO' ORA-06550: line 1, column 7: PL/SQL: Statement ignored The Function written in VB.net that is calling the PLSQL function is pasted below: Public Function GetCurrencyFromScenario(ByVal DataSetType As String, ByVal DataSetName As String, ByVal CurrType As String) Dim returnValue As String Dim db As OracleDbHelper = GetHelper() Dim params As New List(Of OracleParameter) params.Add(OracleParameterFactory.CreateIn("asUserName", OracleDbType.Varchar2, _props.CurrentUser)) 'params.Add(OracleParameterFactory.CreateOut("psError", OracleDbType.Varchar2, 2000)) params.Add(OracleParameterFactory.CreateIn("asDatasetName", OracleDbType.Varchar2, DataSetName)) params.Add(OracleParameterFactory.CreateIn("asDatasetType", OracleDbType.Varchar2, DataSetType)) params.Add(OracleParameterFactory.CreateIn("asCurrType", OracleDbType.Varchar2, CurrType)) params.Add(OracleParameterFactory.CreateOut("asCurrency", OracleDbType.Varchar2)) db.ExecSql_ReaderDataTable(ProcedureName(FPAGET, "GetCurrencyFromScenario"), CommandType.StoredProcedure, params) End Function The PL SQL code that contains the function is called as below: Procedure GetCurrencyFromScenario ( asUserName varchar2, DataSetType varchar2, DataSetName varchar2, CurrType varchar2, asCurrency out fpa_operating_variable.value_text%type) is begin asCurrency := 'EUR'; return; end; I have the same question Show 0 Likes(0) 75062Views Tags: none (add) This content has been marked as final. Show 13 replies 1. Re: ORA-06550: line1,column7: PLS-00306: wrong number or types of arguments 6363 Nov 2, 2012 2:27 PM (in response to 972054) Function as four input arguments an
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle
Ora-06550 Wrong Number Or Types Of Arguments
Scripts Ion Excel-DB Don Burleson Blog
ora-06550 pls-00103 encountered the symbol ORA-06550 Oracle Database Tips by Burleson Consulting The ORA-06550 ora-06550 pls-00302 error is a generic PL/SQL compile error: ORA-06550: line string, column Cause: A PL/SQL compilation error has occurred. The numbers given for line and column are the location https://community.oracle.com/thread/2461757 in the PL/SQL block where the error occurred.Action: Refer to the following PL/SQL messages for more information about the error. The ORA-06550 is error points to the location in the PL/SQL where the syntax error occurred and it is followed by a more descriptive message of the compile-time error: ORA-06550: line 12, column 10: PLS-00302: component 'MY_DEBUGGING' must http://www.dba-oracle.com/t_ora_06550.htm be declared ORA-06550: line 12, column 3: PL/SQL:Statement ignored To learn more about debugging PL/SQL, see the book "Easy Oracle PL/SQL". �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle? Ask a question, help others, and get answers from the community Discussions Start a thread and discuss today's topics http://itknowledgeexchange.techtarget.com/itanswers/how-do-you-get-around-an-ora-06550-error/ with top experts Blogs Read the latest tech blogs written by experienced community members How do you get around an ORA-06550 error? Jonsorr 20 pts. Tags: Thanks! We'll email youwhen relevant content isadded and updated. Following Follow ORA-06550 Thanks! We'll email youwhen relevant content isadded and updated. Following Follow Oracle 10g ora-06550 pls-00103 Thanks! We'll email youwhen relevant content isadded and updated. Following Follow Oracle error messages I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake oracle error ora-06550 they will receive an ora-06550 error on that line number. How can I create an exception that will allow me to give the user a nice message to retype the customer number instead of all of the ORA error lines? How can I write a line of code that will check the user input to make sure it only contains numbers before oracle sees it as an error, since you can't make an exception for a compilation error? Here is my code: set serveroutput on begin declare v_cust_num number := &Customer_Number; v_name varchar2(20); v_address varchar2(20); v_city varchar2(12); v_state varchar2(2); v_zip varchar2(5); begin if v_cust_num < 0 then raise_application_error (-20000,'Customer number can not be negative'); else select firstname || ' ' || lastname, address, city, state, zip into v_name, v_address, v_city, v_state, v_zip from customers where customer#= v_cust_num; dbms_output.put_line(v_name); dbms_output.put_line(v_address); dbms_output.put_line(v_city || ', '|| v_state ||' '|| v_zip); end if; exception when no_data_found then dbms_output.put_line(chr(