Re: PACKAGES, TYPES and STORED PROCEDURES

You might also want to look up this package DBMS_DESCRIBE. It contains only one procedure DESCRIBE_PROCEDURE. It can tell you the return data type of a function. I have not looked into all the details on how it deal with weakly typed and strongly typed ref cursor.

• Jusung Yang

azp74_at_hotmail.com (Alex) wrote in message news:<dca1064b.0302060033.6cdf8856_at_posting.google.com>...
> JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0302051646.30987d18_at_posting.google.com>...
> > Do these ref cursors have to be strongly typed? If not, you can just
> > use a weakly type ref cursor for all your funcitons that return a ref
> > cursor. You don't even have to declare one yourself and just use the
> > SYS_REFCURSOR.
>
> They don't _have_ to be strongly typed, but I don't have any control
> over how the functions may be written. I wanted my app to be as
> generic as possible, so that I wouldn't have to worry about
> strongly/weakly typed cursors.
>
> If no one comes up with any other ideas I might just deal with weakly
> typed cursors only.
>
> Thanks!
Received on Thu Feb 06 2003 - 22:02:11 CET