File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Execute Multiple SQL Queries in PL/SQL Procedure based on parameter

 
Skanda Raman
Ranch Hand
Posts: 205
Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have requirement to execute different sql queries using pl/sql procedure.



In my above proc if i pass PARAM as 1 i need to execute the first query and if PARAM is 2 the second query.

I am using OUT parameter as ref cursor, so that i want to display this results in JSP

However, on compiling this procedure, i am getting below error.



Please let me know where i am doing wrong. I am confused
 
Skanda Raman
Ranch Hand
Posts: 205
Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any Help On this..please
 
Agador Paloi
Ranch Hand
Posts: 118
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
try restructuring your code something like:

 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic