RE: :Oracle problems

christopher.l.hood@xxxxxxxxxxx wrote:
> All,
>
> I am getting the following error while trying to use DBD::Oracle:
>
> DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
> ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
> ./oracleTest.pl line 69.

DESCRIBE is a SQL*Plus command. It is not part of the Oracle SQL language.
You need to either query the data dictionary views directly, or use the
statement handle attributes like NAME, PRECISION, TYPE, etc. to get this
information.
.

Relevant Pages

  • Re: decimal precision
    ... >> not verify the Precision or Scale of Decimal parameter values. ... >> So, when you create Command, which updates database from the dataset, you ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: trouble installing WMP11
    ... Prev version system is ... Setup version 10.00.00.3646.] ... ERROR: WMC_CopyFile: Could not find source file ... Current command line: '/UpdateWMP'. ...
    (microsoft.public.windowsmedia.player)
  • Re: Issue with sat_pop_real()
    ... But i have a "precision" trouble with the command that allow me to pop ... I think that sat_pop_realis kidding me and rounded some decimals. ... you're overflowing the precision of a long double in hpgcc/ARM. ...
    (comp.sys.hp48)
  • Re: how can I use the value of pi with more decimals?
    ... when your display format is set to SHORT. ... Execute the command "format long ... The sine of 2 times (the ratio of the circumference of a circle to its ... precision number, so the MATLAB function pi returns a double precision ...
    (comp.soft-sys.matlab)
  • Re: Unexpected 15 digits precision from "REAL"
    ... variables defined as REAL and not REAL*8, can give so much precision, ... Perhaps the compiler used for the hardcopy source had a similar switch ... The MS v3.31 command has $STORAGE:2 ...
    (comp.lang.fortran)