PH & SQL

[Madeleine D.]

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.