CREATE OR REPLACE TYPE NEW_ADDRS_OBJ
AS OBJECT (newAddress1 varchar2(20),
newAddress2 varchar2(20),
city varchar2(20),
state varchar2(20),
zip number(20))
create or replace type NEW_ADDRS_OBJ_ARRAY as table of NEW_ADDRS_OBJ
CREATE OR REPLACE TYPE ACCOUNT_OBJ
AS OBJECT (fname varchar2(20),
newAddress NEW_ADDRS_OBJ_ARRAY)
create or replace type ...
|
I am trying to retrieve a Blob value thorugh PL/SQL, Spring and JDBC.
Here is my PL/SQL
function GETBLOB(pjobid in number)
RETURN bobrecCur
is
vbobrecCur bobrecCur;
begin
OPEN vbobrecCur FOR
SELECT jobid, ...
|
I want to pass an Arraylist of Objects for e.g.
Arraylist <SomeObject> listOFSomeObject
Where SomeObject is having two attributes key and value.
On DB side i have a table type of variable i.e.
create or ...
|
"java.lang.OutOfMemoryError: Java heap space" due to calling PL/SQL function Hi, I have a problem, when calling a Oracle PL/SQL function which returns a ref cursor, providing a large amount of data. ... |
Call from java to pl sql procedure with table out parameter Hi, There is a similar question with subject "Reading an Oracle ARRAY from a stored procedure out param" but I ... |
Dec 13th, 2004, 07:44 AM #1 colum View Profile View Forum Posts Private Message Junior Member Join Date Dec 2004 Location Cork, Ireland Posts 2 Passing an Array to a PL/SQL ... |
Passing char[] arrays to pl/sql Hi, the forum is littered with code snippets about talking to oracle with complex types but its hard to put it all together to solve my ... |
|
How to call a Stored procedure that is inside the PLSQL package In oracle I have a PLSQL package "Calc_Lib_packg" and there is a procedure name "get_median" what should be the ... |
May 23rd, 2006, 06:36 PM #1 jai View Profile View Forum Posts Private Message Junior Member Join Date May 2006 Posts 2 Passing array to oracle using PLSQL Hi, I've been ... |
creating and calling anonymous plsql block Hi, In my application the user can enter the sql they wish to execute and I then use jdbc to execute this sql (Don't worry ... |
problem returning array from plsql I have some spring code to call a statement against a database on which I only have read access and do not have the ability to ... |
What other way are you looking for besides using Cursor OUT parameters? One other way is to use Oracle Collections but you will have to populate the marshall/unmarshall on your own. ... |
Call from java to pl sql procedure with object types & tables as out parameter Hi All, I want know how my plsql procedure with objects types & collection as out ... |
Hi I am using StoredProcedure class. One of my procedures has input parameter as OracleTypes.PLSQL_INDEX_TABLE for which i need pass null as value. When I set the value as null, it ... |
Hi All, I am new to Spring. I was trying to execute one function by implementing the Spring StoredProcedure class. The function return type is "RECORD". What is the valid java.sql.Types ... |
Param of type PL/SQL Index Table I have a PL/SQL stored procedure that takes 2 parameters of type PL/SQL TABLE. Nothing that I've passed it to this parameter seems to work. ... |
|
Feb 9th, 2010, 05:05 AM #1 Sendilkumar View Profile View Forum Posts Private Message Junior Member Join Date Nov 2009 Posts 7 Pl/SQL Procedure : Problem in passing array of integers ... |
Passing Array of Numbers to PL/SQL stored procedure I have searched the forums and have infact tried out the solutions already posted, but still could not get this to work. PROCEDURE: ... |
May 7th, 2010, 06:26 AM #1 zgrega View Profile View Forum Posts Private Message Junior Member Join Date May 2010 Posts 2 Problem with passing complex type from java to plsql ... |