File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Procedure problem

 
Manish Khindri
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
Felix Anohene
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic