plsql « Database « Spring Q&A

1. Calling Sql procedure from Spring DAO stackoverflow.com

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 ...

2. Read Blob from PL/SQL through Spring stackoverflow.com

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, ...

3. How to pass Arraylist of Objects to a Procedure using spring mybatis stackoverflow.com

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 ...

4. "java.lang.OutOfMemoryError: Java heap space" due to calling PL/SQL function forum.springsource.org

"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. ...

5. Call from java to pl sql procedure with table out parameter forum.springsource.org

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 ...

6. Passing an Array to a PL/SQL Stored Procedure forum.springsource.org

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 ...

7. Passing char[] arrays to pl/sql forum.springsource.org

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 ...

8. How to call a Stored procedure that is inside the PLSQL package forum.springsource.org

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 ...

9. Passing array to oracle using PLSQL forum.springsource.org

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 ...

10. creating and calling anonymous plsql block forum.springsource.org

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 ...

11. problem returning array from plsql forum.springsource.org

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 ...

12. Accessing PL SQL Table output parameter from an Oracle Stored Procedure forum.springsource.org

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. ...

13. Call from java to pl sql procedure with object types & tables as out parameter forum.springsource.org

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 ...

14. Passing null to OracleTypes.PLSQL_INDEX_TABLE forum.springsource.org

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 ...

15. declaraParameter for PL/SQL function with return type RECORD forum.springsource.org

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 ...

16. Param of type PL/SQL Index Table forum.springsource.org

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. ...

17. Pl/SQL Procedure : Problem in passing array of integers to Stored Procedure forum.springsource.org

18. Pl/SQL Procedure : Problem in passing array of integers to Stored Procedure forum.springsource.org

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 ...

19. Passing Array of Numbers to PL/SQL stored procedure forum.springsource.org

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: ...

20. Problem with passing complex type from java to plsql procedure forum.springsource.org

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 ...