RE: Table generation Script for storing Forms & Reports?

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Wed, 27 Sep 2000 08:42:42 -0700
Message-Id: <10632.118011@fatcity.com>

Catproc.sql is not the script you are looking for but it should be run anyway when you create a database. Who did you run that script as? It should be sys (or internal which is the same) not system.

I am not sure where the scripts are that you need to run for storing the forms and reports in the database but they are part of the developer tool, not the database tool. Note that running from the database is slower then the file system. Last time I looked into it Oracle actually recommended not doing it. Oracle is full of ways to hang yourself.

-----Original Message-----
From: Abdul Aleem [mailto:abchaudhary-ho_at_beaconhouse.edu.pk] Sent: Wednesday, September 27, 2000 6:31 AM To: Multiple recipients of list ORACLE-L Subject: Table generation Script for storing Forms & Reports?

Hi!

I am studying a book it says that you can store your forms and Reports to database. It does mention that if the report or form builder does not allow you save to database you need to run a script, but does not tell the script nor its location.

Someone mentioned to run CatProc.SQL located in Oracle_Home\RDBMS\Admin. I did execute the script while connected as "System". One, it did not run successfully, the common reported errors were "insufficient rights" and "object does not exists". Second, the problem of storing forms, reports to database is not solved.

I would appreciate if you could help or pass on the required scripts only.

Regards,

Aleem

-----Original Message-----

Sent:	Wednesday, September 27, 2000 12:21 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: whatz the type of rowid?

Dear Ms. Swapna,

Hi! The datatype of rowid is rowid itself. So if you want to define a variable of datatype which is the same as that of rowid specify rowid itself. Hope this helps.

Regards,

Ranganath

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: RanganathK_at_lgcommerznow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
INET: abchaudhary-ho_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------