Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky Dynamic SQL question
Weak cursors have one weak point: there is no way to describe them
(at least, not in PL/SQL), so you have to know the cursor's %rowtype
before you fetch, and you can't determine it dynamically. With
DBMS_SQL, there's describe_columns(), but the package only works
with scalar data types and doesn't support ADTs...
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "rajXesh" <member_at_dbforums.com> wrote in message news:2318730.1040915829_at_dbforums.com...Received on Fri Dec 27 2002 - 02:48:52 CST
>
> Why dont you try weakely typed ref cursors.
>
> for eg
>
> declare
>
> c sys_refcursor;
>
> begin
>
> -- Get the table name
> v_table_name := fn_get_the_table_name();
>
> open c for ' select * from ' || v_table_name;
>
> end;
>
> -- rajXesh
>
> --
> Posted via http://dbforums.com