ivan at sisd.com
Sat Apr 24 22:12:12 PDT 1999
On Thu, Apr 22, 1999 at 05:10:43PM +0200, Olaf Waitkus wrote:
> 1. Oracle-restrictions:
> - Oracle refused to create tables with columnnames: '_date', 'comment','uid'
Those aren't SQL2 or SQL3 reserved words (see etc/sql-reserved-words.txt
in the distribution), so we'll have to call this an Oracle-specific
problem for now.
Can you send me a list of Oracle reserved words, and a reference as to
where in the documentation it comes from? Even better would be a publicly
> - length Objectnames in Oracle seems to be limited to 30 chars ( thus
> 'cust_bill_pkg__pkgnum_invnum_index' not possible)
> so having changed some column-/table-names i expect future problems,
Yes, you will have problems.
It seems PostgreSQL has similar length restrictions, so the long-term idea
is to keep all column names <= X number of characters. For PostgreSQL, X
seems to be 31. Can you point me to somplace publicly accessable that
says this should be 30 (or 31, or 32, or...?) for Oracle?
> 2. The Problem i posted was solved , thanks to Aaron.
> The next problem i have is: the user who is trying to connect ot the
> database (mapsecrets-contents:: 'freeside fressidefile', freesidefile:
> can't connect to the database.
> i get a
> DBI->connect error: Error while trying to retrieve text for errorORA-12154 (DBDERROR: OCIServerAttach)
> which is a message out of UID.pm,#76
> the apache-log-file states:
> "cust_main.cgi: ORACLE_HOMEenvironmentvariable not set!"
> i have apache configured in a way that its running under user 'freeside'.
> oh yes, the database ist up and running well.
Sorry, your database and DBD::Oracle are not setup and running correctly.
This problem really isn't on-topic for this mailing list, especially since
I don't support Oracle (yet :).
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too
More information about the freeside-users