I have a problem accessing an Oracle stored proc from Java.
the exception thrown is:
java.sql.SQLException: ORA-06550: line 1, column 34:
PLS-00103: Encountered the symbol "." when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
The symbol "<an identifier>" was substituted for "." to continue.
the pl/sql package looks like this:
create or replace package body xyz.PKG_STUD as
PROCEDURE getname(stud_id IN NUMBER,
stud_name OUT VARCHAR2)
IS
BEGIN
SELECT s.student_name INTO stud_name from students s where
s.student_id = stud_id;
END;
any ideas??
TIA