This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic