All Questions
27 questions
0
votes
1
answer
746
views
How to pass column name as parameter in a Stored Procedure in PL/SQL?
I want to pass something like p.lastname or p.first_name in the query_type parameter so that i can order by what i want; and accordingly, query_value would contain something like UPPER('%Smith%') or ...
- 25
1
vote
2
answers
1k
views
How to return a ROWTYPE in PL/SQL and retrieve it in Java?
I have a PL/SQL function , that returns a ROWTYPE. I need to call this function from Java and retrieve the data ( as an array, a map, a struct, a class,whatever, I really don't care , I just need it, ...
- 470
0
votes
1
answer
722
views
Accessing the Custom Object Return type from oracle pl/sql in java
I have created a procedure which signature is as follows :
PROCEDURE CUSTOMER_LIST_FOR_SUSPICIOUS_CHECK (
pCustNo NUMBER,
pCustomerList OUT EMOB.PKG_FINGER.CUSTOMER_LIST,
...
- 2,220
1
vote
1
answer
7k
views
SQL state [99999]; error code [17004]; Type de colonne non valide: 1111
I have this call to PL/SQL function
FUNCTION F_IsDemandeDeLitFromHosp(i_NoMvtHosp IN MVTHOSP.NOMVTHOSP%TYPE
)RETURN BOOLEAN
IS
v_Found NUMBER := 0;
BEGIN
BEGIN
SELECT COUNT(1) INTO ...
- 105
4
votes
1
answer
6k
views
How do I get a stored procedure output parameter that is an array to work?
I have been developing Java/JDBC calls to stored procedures with some success. However I am stuck when an output parameter is an array of strings. I have been successful with scalar types as input and ...
- 12k
1
vote
0
answers
3k
views
Handle oracle ORA-04068:existing state of packages has been discarded in Java Application
I am getting below error in my PROD environment. Some DB call is working fine but some call is throwing exception due to package is discarded/state is invalidate and many reason. But I don't have ...
1
vote
1
answer
813
views
Setting a user-defined SQL TYPE in Java
I have to invoke a Stored Procedure which has an IN parameter as "Type" from Java. Please see below. How to set the "CusInfoList IN CUSTOMER_INFO_LIST -- TYPE" using java?
SQL> create or replace ...
- 21
3
votes
2
answers
5k
views
Send PL/SQL to Oracle without creating a stored procedure
I am a total newbie in PL/SQL Oracle. I am used to work with JDBC framework and standard SQL.
For example, the next PL/SQL:
IF EXISTS (SELECT * FROM Table1 WHERE Column1=’SomeValue’)
UPDATE ...
- 1,947
2
votes
1
answer
5k
views
SQLException: ORA-01403: no data found when passing an array to a StoredProcedure
I'm trying to pass an Java String array to a PLSQL Stored-Procedure. After a lot of searching the internet I found a solution which does not work for me.
First of all here is the package i declared ...
- 399
0
votes
0
answers
482
views
How can I get a table from PL/SQL procedure in Java?
I have got a package which contains a cursor, a table type on that cursor and a function that returns the table.
create or replace package RAPI is
cursor coordAndImgCursor is select latitude, ...
- 340
0
votes
0
answers
2k
views
Calling oracle pl sql stored procedure with IN parameter as Record type using Java
I want to call oracle pl/sql stored procedure with IN parameter as Record type using Java.
I have tried JDBC connection,Hibernate and also JPA,
but i am getting one error:
java.sql.SQLException: ...
- 143
2
votes
1
answer
831
views
Incorrect order of binded params in oracle stored proc called from Java using JDBC callable statement
Following is the oracle proc call from java using binded params -
String GET_TEST_ID = "{call PKG_TEST.prc_gettestid(:PARAM1, :PARAM2, :PARAM3, :OUTPARAM1)}";
String id = (String)getJdbcTemplate()....
- 69.2k
15
votes
1
answer
49k
views
How to call a stored procedure in JDBC
For homework I have to create a pl/sql stored procedure to add a facutly member to a database
CREATE OR REPLACE PROCEDURE ADDFACULTYDEPTSAL
(facid IN NUMBER,
facname IN VARCHAR,
depID IN NUMBER)...
- 472
2
votes
2
answers
4k
views
Oracle JDBC / PL SQL / TYPE / Package Level / Invalid Name Pattern
I have declared package level type this way (using Oracle XE 11):
create or replace PACKAGE RM_TYPES
AS
TYPE RECPPART_ARR IS TABLE OF RM_RECEPCIONPARTIDAS%ROWTYPE;
END RM_TYPES;
I have SP like ...
- 4,535
0
votes
1
answer
190
views
Invalid Pattern name; Oracle Stored Procedure Input Parameter
I have a JDBC program to which uses a CallabaleStatement object to set and register IN/OUT parameters for the stored procedure.
I have used ArrayDescriptors and oracle.sql.ARRAY object and set it as ...
- 160