LakshmanaRavula
asked on
How to get Return String from Oracle Procedure in Java class
Hi
Iam Calling Stored Procedure (Oracle 9i, J2ee)
Object of Stored procedure to insert Data into a table in this process it makes 2 calls to other tables get relevant data
finally insert Row into target table.
In my procedure i have appended Error messages with separated by ","
How can i get this return string
Here is my code
strSql = "{? = call package.proc_name(?,?,?,?,
cstmt = connection.prepareCall(str
cstmt.setLong(1, Long.parseLong(form.search
..........................
cstmt.executeUpdate();
How to get return string from Procedure
-Lakshmana
Iam Calling Stored Procedure (Oracle 9i, J2ee)
Object of Stored procedure to insert Data into a table in this process it makes 2 calls to other tables get relevant data
finally insert Row into target table.
In my procedure i have appended Error messages with separated by ","
How can i get this return string
Here is my code
strSql = "{? = call package.proc_name(?,?,?,?,
cstmt = connection.prepareCall(str
cstmt.setLong(1, Long.parseLong(form.search
..........................
cstmt.executeUpdate();
How to get return string from Procedure
-Lakshmana
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
