RE: Table generation Script for storing Forms & Reports?

From: <alan.aschenbrenner_at_ihs.com>
Date: Wed, 27 Sep 2000 09:24:50 -0600
Message-Id: <10632.118003@fatcity.com>

Aleem,

    The reason catproc.sql didn't complete successfully is because it needs to be run as SYS (or internal). That should clear up your "insufficient rights" errors. But, after you re-run catproc as SYS, you may have duplicate objects (owned by sys and system). You'll need to drop the objects owned by system.

HTH, Alan

Alan Aschenbrenner
Oracle DBA
IHS Group, Denver Colorado
alan.aschenbrenner_at_ihs.com <mailto:alan.aschenbrenner_at_his.com>

	-----Original Message-----
	From:	Abdul Aleem [SMTP:abchaudhary-ho_at_beaconhouse.edu.pk]
	Sent:	Wednesday, September 27, 2000 7: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
	--------------------------------------------------------------------
	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

Received on Wed Sep 27 2000 - 10:24:50 CDT