Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC 16615-Executing-anonymous-pl Executing anonymous pl/sql block and get resultset in Java
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Praveen
Executing anonymous pl/sql block and get resultset in Java
0 Answer(s)      3 years and 8 months ago
Posted in : JDBC


Hello All,

I would like to execute the anonymous pl sql block and need to get the resultset object. I got the code which can be done by using cursors inside the pl sql block.

But the pl sql block itself will come from the database as text. So i cant edit that pl sql block. And it will return only two values whose column names will be same always.

Here i am giving sample pl sql block.

BEGIN

RETURN

'select distinct fundname d, fundname r from LOVFUNDDETAILS

where condition

order by 1';

EXCEPTION

WHEN OTHERS THEN

RETURN

'SELECT ''Not Available'' d, ''Not Available'' r FROM dual';

END;

Any help will be greatly appreciated.

Regards,

Raj


Advertisement
View Answers

Related Tutorials/Questions & Answers:
Executing anonymous pl/sql block and get resultset in Java
Executing anonymous pl/sql block and get resultset in Java  Hello All, I would like to execute the anonymous pl sql block and need to get the resultset object. I got the code which can be done by using cursors inside the pl sql
PL/SQL tables
PL/SQL tables   hii, Describe the use of PL/SQL tables ?   hello, PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries or calculations
Advertisements
java anonymous class
java anonymous class  Can an anonymous class be declared as implementing an interface and extending a class
Toby's PL/SQL Editor
Toby's PL/SQL Editor What is the PL/SQL Editor? The PL/SQL editor is a plugin... easily develop and test PL/SQL code. Download You can download the plugin...) of the existing features. PL/SQL Syntax Colouring
executing mysql plsql block using hibernate
executing mysql plsql block using hibernate  I got one requirement like this, I have to execute following query by using hibernate DECLARE @i_STARTDATETIME DATETIME DECLARE @i_ENDDATETIME DATETIME DECLARE @o_ERRORCODE INT
Describe the use of PL/SQL tables
Describe the use of PL/SQL tables  Describe the use of PL/SQL tables   Hi, PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries
PL/SQL Terms
PL/SQL Terms       SQL SQL is an English like language consisting of commands to store, retrieve, maintain & regulate access to your database.   
How are Anonymous (inner) classes used in Java?
How are Anonymous (inner) classes used in Java?  How are Anonymous (inner) classes used in Java
Java Function for block inside a block
Java Function for block inside a block  Write a function in Java that attempts to place a set of squares of varying widths into another, larger square. If there is no possible layout, return undefined. Otherwise, return
Java Function for block inside a block
Java Function for block inside a block  Write a function in Java that attempts to place a set of squares of varying widths into another, larger square. If there is no possible layout, return undefined. Otherwise, return
Getting the Records in PL/SQl between Date Ranges - JDBC
Getting the Records in PL/SQl between Date Ranges  Getting the records Between the Dates in PL/SQL Database by using JDBC and display through JSP
while executing a java program
while executing a java program  while iam executing a simple java program after i type "java simple.java" there was a an error occuring.the error is "exception in thread "main" java.lang.noclassdeffounderror:simple" what thus
URL Block - Java Beginners
URL Block  Hello sir, How to block one website using java.for example if we want block "www.orkut.com" site,how to block this site using java... to block a URL like this?please help me.. Thanking you
doubt on synchronized block in java
doubt on synchronized block in java  Hi ! some people are feeling... am a beginner.I am learning java with out any teacher.I need your valuable suggestinons.Today i am going to ask on synchronized block. the general form
ResultSet In Java
that are mostly used in to get the value. ResultSet contains the data of a table after executing the SQL queries. Object of ResultSet also maintains the current position...ResultSet In Java In this section we will learn about the ResultSet in Java
Executing Set of SQL statements in Java
Executing Set of SQL statements in Java  Hi, I am trying to execute a procedure which is stored in MS SQL server's database. I have configured..."); cstmt=conn.prepareCall("{proc_name}"); ResultSet rs
executing java program with 2 classes
executing java program with 2 classes  how to run a program of java containing more than one class....ex of program is given below.... class C...); } }   Executing java program with 2 classes save the file with D.java
ResultSet
ResultSet   What is a ResultSet
Scrollable ResultSet - Java Beginners
to get the count of records. in a select operation like sqlstmt="SELECT * FROM... get the number of record for the Query. Your Answers use the scrollable result set, first move the pointer from first record to last record and get
anonymous class
anonymous class  what actually is an anonymous class and what is the use of it along with the simple example? if there is a video explaining it that will be fine
ResultSet
ResultSet  What is a ResultSet
ResultSet object initialization - Java Beginners
ResultSet object initialization  How to initialize resultset object  Hi friend, public interface ResultSet A ResultSet object maintains a cursor pointing to its current row of data. A default ResultSet object
Get Column Count using ResultSet in SQL
Get Column Count using ResultSet in SQL   .... The ResultSetMetaData interface can be used to get type and properties information of columns in a ResultSet. The ResultSetMetaData object can be obtained by invoking
java programe executing error - Java Beginners
java programe executing error  i am creating one package to one class... Friend, If you have following java class: package newp; class Hello...!"); } } Compile as: javac -d Hello.java Execute it: java Hello
ResultSet
ResultSet  I want to retrieve data of unknown datatype from database.how to do it using resultset or Resultsetmetadata.Can you please tell me what... = con.createStatement(); ResultSet rs = st.executeQuery
Anonymous Classes
executing a given anonymous class definition. Anonymous classes can...Anonymous Classes       A local class that is defined without a name is known as Anonymous class
Anonymous Inner Classes - Anonymous Inner Classes tutorial
.style1 { text-align: center; } Anonymous Inner Classes Except... it is known as anonymous inner classes. Here we are discussing  anonymous inner classes. The anonymous inner classes is very useful in some situation
Problem in executing macro enabled excel sheet using java
Problem in executing macro enabled excel sheet using java  Hi, I have written a java code which will read a excel sheet with macro enabled. then it will write data into sheet1 and sheet2 and it will execute a VB script
multiple resultset in one resultset
multiple resultset in one resultset  how to retrive multiple resultsets in one resultset in java.? plz help
Java Code to Block a website accessed by any browser in windows
Java Code to Block a website accessed by any browser in windows  I want create an application in Java through Netbean IDE to block any website to be accessed by any browser. I also want to display only its html contents. please
What is Anonymous FTP?
know What is anonymous FTP? Access to FTP server can be managed in two ways Anonymous and Authenticated.  In the anonymous FTP, the host providing FTP service may provide anonymous FTP access. In this case, the user log
Advertisements
 

 

 

DMCA.com