Re: Dynamic sql (built on the fly)

I'll have to check out my archives for examples. I don't think I ever did an open-ended PL/SQL parser of this type, although I think I have a Pro*C one. Give me a few days.

dbms_sql should be installed: it goes in under catproc.sql during standard database creation, but you may not have execute privilege on it.

To check existence - connect as SYS and do

    column object_name format a30
    select object_type, object_name, status     from dba_objects
    where object_type like 'PACKAGE%'
    ;

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

huh wrote in message <7ldbhm$29cf$1_at_ns.felk.cvut.cz>...
>Jonathan,
>
>Would you mind sending (or pointing)
>us a simple example?
>
>BTW: Do I need to install dbms_sql package
>or is it ensured that this package is installed?
>How can I find what packages have already
>been installed on our server?
>What about the V$xxx objects? Do I need to run
>any scripts or is it ensured that these views
>are installed? How can I find what is installed?
Received on Wed Jun 30 1999 - 13:21:06 CDT