Hello list,
A sysadmin and a DBA here, both stumped!
We're running Oracle 8i on RedHat 6.1 Secure with the ArsDigita
Community System (ACS) and AOLServer. That may not mean anything to any
of you; the relevant point is that the ACS (which requires Oracle) and
AOLServer (which just uses whatever db connection the ACS has) are
speaking properly to the database and to one another, the tables have
automagically assembled themselves with the proper attributes, etc.
However, when we attempt to insert values into the tables in the
community system, we're getting a VERY strange error:
ORA-01403: no data found
The insert does not commit and the table remains empty.
We have verified: (a) there are no triggers running based upon an insert
into this table (b) no other errors are being generated (c) the same
results occur if we insert data into the table in exactly the same order
as is listed in the DESCRIBE results below.
Any lurking DBAs out there who can help us figure out what the )&^#$ is
going on?
relevant data:
------------------------------------------------------------------------
--------
SQL> describe users
Name Null? Type
----------------------------------------- -------- --------------------
--------
USER_ID NOT NULL NUMBER(38)
FIRST_NAMES NOT NULL VARCHAR2(100)
LAST_NAME NOT NULL VARCHAR2(100)
SCREEN_NAME VARCHAR2(100)
PRIV_NAME NUMBER(38)
EMAIL NOT NULL VARCHAR2(100)
PRIV_EMAIL NUMBER(38)
EMAIL_BOUNCING_P CHAR(1)
CONVERTED_P CHAR(1)
PASSWORD NOT NULL VARCHAR2(30)
URL VARCHAR2(200)
ON_VACATION_UNTIL DATE
LAST_VISIT DATE
SECOND_TO_LAST_VISIT DATE
N_SESSIONS NUMBER(38)
REGISTRATION_DATE DATE
REGISTRATION_IP VARCHAR2(50)
USER_STATE VARCHAR2(100)
APPROVED_DATE DATE
APPROVING_USER NUMBER(38)
APPROVING_NOTE VARCHAR2(4000)
EMAIL_VERIFIED_DATE DATE
REJECTED_DATE DATE
REJECTING_USER NUMBER(38)
REJECTING_NOTE VARCHAR2(4000)
DELETED_DATE DATE
DELETING_USER NUMBER(38)
DELETING_NOTE VARCHAR2(4000)
BANNED_DATE DATE
BANNING_USER NUMBER(38)
BANNING_NOTE VARCHAR2(4000)
CRM_STATE VARCHAR2(50)
CRM_STATE_ENTERED_DATE DATE
PORTRAIT BLOB
PORTRAIT_UPLOAD_DATE DATE
PORTRAIT_COMMENT VARCHAR2(4000)
PORTRAIT_CLIENT_FILE_NAME VARCHAR2(500)
PORTRAIT_FILE_TYPE VARCHAR2(100)
PORTRAIT_FILE_EXTENSION VARCHAR2(50)
PORTRAIT_ORIGINAL_WIDTH NUMBER(38)
PORTRAIT_ORIGINAL_HEIGHT NUMBER(38)
PORTRAIT_THUMBNAIL BLOB
PORTRAIT_THUMBNAIL_WIDTH NUMBER(38)
PORTRAIT_THUMBNAIL_HEIGHT NUMBER(38)
BIO VARCHAR2(4000);
SQL> INSERT INTO users (user_id,
email,
password,
first_names,
last_name,
url,
registration_date,
registration_ip,
user_state,
last_visit)
VALUES (44,
'[EMAIL PROTECTED]',
'password',
'Alice',
'Lidell',
'',
sysdate,
'192.168.0.101',
'authorized',
sysdate);
ERROR at line 1:
ORA-01403: no data found
SQL>
_______________________________________________
techtalk mailing list
[EMAIL PROTECTED]
http://www.linux.org.uk/mailman/listinfo/techtalk
