Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table generation Script for storing Forms & Reports?
You have to run catproc as sys.
BTW, do have any general hints on using Oracle forms/reports for
development? Any specifics would e of help.
Bryan M. Miller
Junior Oracle DBA
IT Operations
Telergy Inc.
Email: bmiller_at_telergy.net Phone: (315)362-2642 Pager: (315)647-1908 -----Original Message----- From: Joan Hsieh [mailto:jhsieh_at_infonet.tufts.edu] Sent: Wednesday, September 27, 2000 11:41 AM To: Multiple recipients of list ORACLE-L Subject: Re: Table generation Script for storingForms & Reports?
It should run as sys not system.
JOan
Abdul Aleem wrote:Mailing Lists
>
> 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
> also send the HELP command for other information (like
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: jhsieh_at_infonet.tufts.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access /
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).Received on Wed Sep 27 2000 - 09:51:21 CDT
![]() |
![]() |