Re: Accessing a weak refcursor

From: joel garry <joel-garry_at_home.com>
Date: Tue, 7 Sep 2010 09:45:51 -0700 (PDT)
Message-ID: <00511090-b460-4b67-91e3-3f6173e530e5_at_x20g2000pro.googlegroups.com>

On Sep 7, 6:55 am, Knickerless Parsons <knickerlesspars..._at_gmail.com> wrote:
> Hi all,
> I'm trying to write a clever stored procedure that I can pass in a
> table name and a where clause, and it'll display all matching rows in
> a firendly manner.
>
> For example:

...

>          -- Strip off the trailing comma and space
>          w_sql := SUBSTR(w_sql,1,LENGTH(w_sql) -2) ;
>          --
>          -- Add the from and where cluases
>          w_sql := w_sql || ' FROM ' || p_owner || '.' || p_table || '
> WHERE ' || p_where ;
>
>          --
>          -- Diagnostic to display the SQL
>          DBMS_OUTPUT.PUT_LINE('Generated the following SQL...') ;
>          wrap(w_sql,80) ;
>
>          OPEN w_get_data FOR w_sql ;
>
>          -- ????????????????????
>          CLOSE w_get_data ;
>
>       ELSE
>          DBMS_OUTPUT.PUT_LINE('Table ' || p_owner || '.' || p_table ||
> ' not found!') ;
>       END IF ;
>       CLOSE c_get_cols ;
>    EXCEPTION
>       WHEN OTHERS THEN
>          DBMS_OUTPUT.PUT_LINE('[' || SQLERRM || ']') ;
>    END showme ;
>
> BEGIN
>    showme('DAVE','JOBS','JOB_NUMBER=''123''') ;
> END ;
> /

This kind of thing is out of my comfort zone, but see http://www.morganslibrary.com/hci/hci003.html

jg

--
_at_home.com is bogus.
http://www.marketwatch.com/story/oracle-shares-jump-as-mark-hurd-joins-firm-2010-09-07

Received on Tue Sep 07 2010 - 11:45:51 CDT