• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Oracle Procedure problem

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I am using Style Report Enterprise Edition 5.0.In that i am calling a Oracle Stored procedure with a 1 IN parameter and 3 OUT Parameter.
The procedure is given below
CREATE OR REPLACE PROCEDURE Employeedetails(
i_emIDINEMPLOYEE.em_id%TYPE,
o_FirstName OUT EMPLOYEE.em_first_name%TYPE,
o_LastNameOUTEMPLOYEE.em_last_name%TYPE,
o_SalaryOUTEMPLOYEE.em_salary%TYPE,
o_StartDateOUTEMPLOYEE.em_start_date%TYPE)
IS
BEGIN
SELECT em_first_name,
em_last_name,
em_salary,
em_start_date
INTO o_FirstName,
o_LastName,
o_Salary,
o_StartDate
FROM EMPLOYEE
WHERE em_id = i_emID;
END Employeedetails;
/

And I am setting the IN parameter as a prompt Value which i specify but after that i get this error

About to execute "{ call PTS.EMPLOYEE1.EMPLOYEE1( ? ,?)}"
inputParameter #1="1" (class java.lang.Integer)
java.sql.SQLException: ORA-06550: line 1, column 21:
PLS-00225: subprogram or cursor 'EMPLOYEE1' reference is out of scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Can anybody help me even if u dont know the Style report. Whats will be the main cause of such type of errors
 
Manish Khindri
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There is slight modification of error

About to execute "{ call PTS.EMPLOYEEDETAILS.EMPLOYEEDETAILS( ? ,?,?,?,?)}"
inputParameter #1="1" (class java.lang.Integer)
java.sql.SQLException: ORA-06550: line 1, column 27:
PLS-00225: subprogram or cursor 'EMPLOYEEDETAILS' reference is out of scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oracle is having a problem resolving your procesdure name. In the call of the procedure use <your schema name>.EMPLOYEEDETAILS.
The error code "pls-00225, subprogram or cursor reference '%EMPLOYEEDETAILS' is out of scope. " means there is a problem resolving a object reference or variable name in the plsql program. Check for duplicate variable declarations, or objects on the sys, system and the user schema, for any possible conflicts. Select object_name, object_type, owner from dba_objects where object_name like '%<problem reference%>'; should help you identify the different objects existent in your system and the different schemas with the same name and that may be causing the reference conflict.
 
reply
    Bookmark Topic Watch Topic
  • New Topic