Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to understand which datatype is being output from a stored procedure

 
Shantanu Deshmukh
Greenhorn
Posts: 23
Java jQuery PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I am trying to write a function which takes stored procedure's name and it's arguments as argument and execute it.
Now I want that, the function should be able to know wat data is being output from the sp, so I can set datatype of output variable of sp.

How to do this ?
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Shantanu,

I guess you have to look up for your procedure in database metadata and learn about it in details. But there are many things to be considered like how many and what types of arguments does the procedure have? How to handle CLOB, BLOB and raw types? What about UDTs?

You are on a dark path, good luck with that

I am sure some other rancher will give a hand.

Regards,
Fatih.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!