Home » SQL & PL/SQL » SQL & PL/SQL » Call from Java Plsql Procedure with VArray as Out Parameter (Windows XP, Oracle 9i)
Call from Java Plsql Procedure with VArray as Out Parameter [message #304250] Tue, 04 March 2008 12:10 Go to next message
drink25up
Messages: 11
Registered: March 2008
Junior Member
Hi,

I have a Java web application(Tomcat server) that call a plsql procedure with Varray as o/p parameter.
The Plsql code is perfectly compiled.
When i run the application, I get the following error msg in my Tomcat window:

java.sql.SQLException: ORA-06530: Reference to uninitialized composite
ORA-06512: at "SEMS1.PACK_SEMSADMIN_OFFEREDJOBS", line 102

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:109
3)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat


I am attaching my Plsql procedure.
Its a small package with 1 procedure.

I think i need to initialize my VArray somewhere in the specification.. but I dont know where and how it has to be included.

VARRAY DETAILS:

TYPE STRUCT_JOB_DETAILS AS OBJECT
(
APPL_NO NUMBER (10),
S_FNAME VARCHAR2 (32 Byte),
S_MI VARCHAR2 (32 Byte),
S_LNAME VARCHAR2 (32 Byte),
APPL_DATE DATE,
DESCRIPTION VARCHAR2 (100 Byte),
S_UCID VARCHAR2 (8 Byte)
);

TYPE VARRAY_JOB_DETAILS IS VARRAY(100) OF STRUCT_JOB_DETAILS;


Reqire help plzzzz !!!

Thanks.
Re: Call from Java Plsql Procedure with VArray as Out Parameter [message #304257 is a reply to message #304250] Tue, 04 March 2008 12:23 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Regards
Michel
Previous Topic: How to Change Language and characterset dynamically.
Next Topic: Using Dual to Generate Rows - Virtual Table
Goto Forum:
  


Current Time: Tue Dec 06 04:08:23 CST 2016

Total time taken to generate the page: 0.10533 seconds