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
Post a Comment