Insert Problem

From: Jerry Metz <JMetz1_at_ix.netcom.com>
Date: Thu, 18 Mar 1999 07:44:19 -0600
Message-ID: <36F10333.65B3E0BA@ix.netcom.com>

We are having a problem here that is threatening to leave us with significantly less hair than we started out with. We are running Oracle 7.3.4, and independantly, PO7 (7.3). We are also using PowerBuilder 5.0.4 as the front-end tool. I have a PB program that encrypts a user's changed password and then should update that change into an Oracle table. The resultant SQL statement is as follows:

update security

     set password = '›­ΌΓ΄',
     inactive_date = to_date('06/15/1999','MM/DD/YYYY')

where user_code = 'HESSD'

The interesting thing here is that this statement works just fine in PO7, but gives me a SQL Statement requires termination error on the 7.3.4 instance. My gut feeling is that the server based Oracle (7.3.4) is finding something in this as a termination character where it shouldn't. Does anybody have any suggestions as to how I can get this to work?

Thanks.
Jerry Received on Thu Mar 18 1999 - 07:44:19 CST