Ora-06550 Pls-00201 Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About ora-06550 pls-00201 identifier must be declared oracle Us Learn more about Stack Overflow the company Business Learn more about hiring ora-06550 identifier must be declared stored procedure developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Pls-00201 Identifier Must Be Declared Stored Procedure
the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle SP giving PLS-00201 ORA-06550
Ora-06550: Line 1, Column 7: Pl/sql: Statement Ignored
error up vote 1 down vote favorite I have created a SP as below: The purpose is the pass 2 params to xyz. The SP xyz will read records from a table t1 and store in a cursor. xyz in turn will call another SP sp2 in a loop with the records stored in the cursor. When I tried to run this in TOAD, I got pls-00201 identifier must be declared procedure the error ORA-06550: line 2, column 3: PLS-00201: identifier 'abc.xyz' must be declared ORA-06550: line 2, column 3: PL/SQL: Statement ignored create or replace PROCEDURE abc.xyz(year IN number, ver IN number) IS cursor my_cur (year IN number, ver IN number) IS select p1, p2, p3, p4, p5, p6 from abc.t1 where p2=year and p3=ver; my_row my_cur%rowtype; params varchar2(1000); BEGIN for IN my_cur(year, ver) loop params := '' || my_row.p1 || '' ||',' || my_row.p2 || ',' || my_row.p3 || ',' || my_row.p4 || ',' || my_row.p5 || ',' || '' || my_row.p6 || '' dbms_output.put_line(params); exec sp2(params); params := ''; end loop; END; oracle stored-procedures share|improve this question edited Oct 22 '13 at 17:55 asked Oct 22 '13 at 17:31 TipTop 2718 Do you mean to create a procedure with a name with a dot in it? Or do you really want to create a package with a procedure in it? –Colin 't Hart Oct 22 '13 at 18:33 @Colin'tHart, I am find with the SP, I would like to know how to add a single quote around my_row.p1 in the params. Can you tell me how to do that? –TipTo
here for a quick overview of the site Help Center Detailed answers to any questions you
Java Sql Sqlexception Ora 06550 Line 1 Column 7
might have Meta Discuss the workings and policies of this site pls 00201 identifier must be declared oracle package About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or must be declared ora-06550 line 1 column 7 pl/sql statement ignored posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of http://stackoverflow.com/questions/19524607/oracle-sp-giving-pls-00201-ora-06550-error 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-06550: line 1, column 7: PLS-00201: identifier exception up vote 0 down vote favorite Below are the procedure and the code. Even though the signature is same, i am getting the error ORA-06550 procedure prc_MediaProSchExport(c_ResultSet OUT http://stackoverflow.com/questions/24953030/ora-06550-line-1-column-7-pls-00201-identifier-exception t_Cursor, vChas IN Varchar2, vTXS IN Date, vTXE IN Date, vSch IN Varchar2 ) OracleParameter oParam = new OracleParameter("c_ResultSet", OracleDbType.RefCursor); oParam.Direction = ParameterDirection.ReturnValue; parameterList[0] = oParam; OracleParameter oParam1 = new OracleParameter("VARI", OracleDbType.Varchar2); oParam1.Direction = ParameterDirection.Input; parameterList[1] = oParam1; DateTime gmtDateTime = DateTime.Parse(DateTime.Today.ToShortDateString()); OracleParameter oParam2 = new OracleParameter(gmtDateTime.ToString(), OracleDbType.Date); oParam2.Direction = ParameterDirection.Input; parameterList[2] = oParam2; OracleParameter oParam3 = new OracleParameter(gmtDateTime.ToString(), OracleDbType.Date); oParam3.Direction = ParameterDirection.Input; parameterList[3] = oParam3; OracleParameter oParam4 = new OracleParameter("ABCD", OracleDbType.Varchar2); oParam4.Direction = ParameterDirection.Input; parameterList[4] = oParam4; c# oracle share|improve this question asked Jul 25 '14 at 9:58 Siddam Shetty Rahul 63 The "PLS-00201: identifier exception" error message could also point to a misspelling of your procedure name itself when you call it. Can you please add the procedure call as well as the full error stack in your code example above. –gvenzl Jul 25 '14 at 10:30 Got the answer.It should be parameter name not the value. gmtDateTime.ToString() shouldnt be. –Siddam Shetty Rahul Jul