printing out result-set from stored procedure

4 views
Skip to first unread message

Ram

unread,
Dec 13, 2009, 10:14:13 AM12/13/09
to DB Solo
Hi,

Is there an staright forward method to print the out sys_refcursor
from procedure?

So far, the only way I can do it is to manually fetch into the cursor
and print each column.. which means i would have to declare every
column i want to print.. I am trying to find out if there is an easier
way to do this.


-ram

DB Solo

unread,
Dec 13, 2009, 10:18:25 AM12/13/09
to db-...@googlegroups.com
As far as I know there is no way to do this automatically, you need to
do it manually like you said.

Marko
> --
>
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>
>
>

Ram

unread,
Dec 13, 2009, 10:22:30 AM12/13/09
to DB Solo
I am trying this with Oracle 9.2 Enterprise Edition server. My system
config:
Db Solo ver. 3.7.7
Linux (CrunchBang)
Oracle Thin Driver (/usr/local/dbsolo3/lib/ojdbc14.jar)

Ram

unread,
Dec 13, 2009, 10:26:53 AM12/13/09
to DB Solo
Will this kind of feature be included in a future release?

DB Solo

unread,
Dec 13, 2009, 10:40:43 AM12/13/09
to db-...@googlegroups.com
Can you provide an example of what exactly you are looking for and
which part of DB Solo are you referring to?

Thanks,
Marko
Reply all
Reply to author
Forward
0 new messages