Re: ORACLE ODESCR error -24363

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Wed, May 26, 1999 at 04:38:31PM -0400, Doug Cummings wrote:
> The table being read is being accessed through Oracle's gateway to
> turbo-image (HP3000 database). The SQR uses a large number of arrays
> to speed processing.
>
> Any ideas?
[...]
>
> (SQR 5528) ORACLE ODESCR error -24363 in cursor 14:
>    ORA-24363: measurements in characters illegal here
> (SQR 1303) Error in SQL (perhaps missing &name after expression):
> select A.itno, A.uom, A.imu2arr_1, A.imr2arr_1, A.adddat, A.bcode, A.glacct,
> A.fltime, A.ccode, A.clcodarr_2, A.clcodarr_3, A.scode, A.actstat, A.rev,
> A.inspcode, A.vcode, A.dlt  from     IM A order by A.itno
> (SQR 1304) Check SELECT columns, expressions and 'where' clause for syntax.
>
> SQR: Program Aborting.

I've never had this error myself, but here's what the Oracle manual
says about it:
  ORA-24363: measurements in characters illegal here

  Cause: Measurements in characters instead of bytes are illegal if either
  the server's or client's character set is varying width.

  Action: If either the client's or server's character set is varying
  width then do not use the OCI_ATTR_CHAR_COUNT attribute for
  the bind handle. Use OCI_ATTR_MAXDATA_SIZE instead.

So, one thing to check is if either your Oracle or your
Turbo-image/Oracle gateway are configured to use any variable-width
character sets.

If you don't find any problems along these lines, then you might
possibly have hit an SQR bug (since you don't have any control over the
OCI_ATTR_* attributes used in the bind handle...).

Is this a run-time or compile-time error?  I was getting a different
error, but the last time I ran into a bizzare run-time error like this,
the problem went away when I re-linked SQR.  (Look in $SQRDIR/../lib for
the sqrmake script.) This could well be necessary if you've upgraded
HP/UX or Oracle.


                                                Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/