variable « Oracle « JPA Q&A





1. GenericJDBCException with ORA-01008: not all variables bound    forum.hibernate.org

Hi I am trying to work out the first hibernate example Event in hibernate.org. I am using oracle as databse. Since I cannot create a sequence in the database, I used 'assigned' as the generator class. The thing I don't understand is, when we gibe 'assigned' ,where should we set the key value ? In the table , or do we ...

2. ORA-01008: not all variables bound Exception    forum.hibernate.org

Hi All, I am using Spring Framework and Hibernate...I have a stored procedure which is to called from the program... Stored Proc is : CREATE OR REPLACE PROCEDURE getDeptEntries(dnam OUT VARCHAR2,dno IN NUMBER) AS sCall VARCHAR2(500); nTotal VARCHAR2(50); BEGIN sCall := 'SELECT dname FROM DEPT WHERE DEPTNO = :dno'; EXECUTE IMMEDIATE sCall INTO nTotal; dnam := nTotal; end getDeptEntries; And the ...