PH & SQL

[Jones Allen (Van)]

The message from the Oracle manual says:

Cause: A conversion request cannot be performed because a digit was invalid.

Action: Fix the number and retry. 

It seems that a conversion is taking place somewhere.  It may be internal to
Oracle or Powerhouse, but it may be in your own programs.  Do you have any
triggers on the table or column?  What happens if you simulate the problem
entirely in Oracle using a PL/SQL procedure or an insert statement in
SQL*Plus?

-----Original Message-----
From: Madeleine D. [mailto:mmdrake@bctonline.com]
Sent: Friday, January 26, 2001 12:16 PM
To: powerh-l@sphere.swau.edu
Subject: PH & SQL


A question for PH-Imbedded SQL:

We have an HP-UX installation, using PH813d3 and Oracle 8.0.5.  I have put
together a ghost screen to export records, based on given criteria, via
imbedded SQL and an Oracle link to an Oracle table at another division.  I
use PH Cursor and SQL OPEN statements to access the table, with temporaries
to load the values.  The code looks basically like:

 SQL INSERT into PO_TEST   &
  (TRANSACTION_ID,DESCRIPTION,PARTNO)  &
  VALUES  &
  (:T_RCPT_TRANSID, 101, :T_RCPT_PARTNO)

Everything works just fine, except:  I need to send a NULL on a numeric
field if one of my PO Record fields has a given content, so I have:

IF PO_FIELD = "CONTENT"
THEN LET T_NUMERIC = NULL

That seems to work just fine on a similar character field, but the numeric
causes a load failure everytime.  Oracle spits back:

------------------------------
ORA-01488: invalid nibble or byte in the input data
------------------------------

Without the numeric field in the SQL statement, everything loads just fine.


So, any ideas as to what I might do?  I can't just not send the field,
because depending on criteria, it will have content.  I know I could
conditionalize the SQL INSERT, but it would be nice to know why this is
happening.

thanks in advance.

Madeleine D.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.