database - PLS-00201 Error when running stored procedure in Oracle -


I recently moved to the oracle database for one of my projects I used to select several rows from the database Created The following is my process

  or choose Open p_cursor * from branch_info * to open the form of Practical Test (p_cursor OUT SYS_REFCURSOR); End test;   

When I execute this process, I found the following error:

  * Error in line 1: ORA-066: Line 1, column 7: PLS-00201: Identifier 'SAURAV.TEST' should be declared ORA-06550: Line 1, Column 7: PL / SQL: Statement ignored   

I have Searching and the same question but error line has been found

Edit: Misspint Test with text < / Div>

Help any person solve this problem

The problem is with the test of the keyword

  create or test the process (p_cursor OUT sys_refcursor) Open p_cursor for selection as * from Branch_info; End Test;   

and

  performed by the variable RC refraction; Exec test (: RC); Print rc; Ora-0650: Line 1, Column 7: PLS -0201: Identifier 'Test' should be declared ORA-0650: Line 1, Column 7: PL / SQL: Ignore Statement   < P> Change some other names  
  or open p_cursor to start as practice exam 2 (pc ceroute cs_fracusers) * from branch_info; END test2;   

executed as

  variable RC rifers; Exec test2 (: RC); Print rc; The PL / SQL process successfully completed   

from SQL Plus

  SQL & gt; Variable usercur references; SQL & gt; DECLARE 2 BEGIN 3 test2 (: usercur); 4th; 5 / PL / SQL Process successfully complete SQL & gt; Print users;    

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -