Home » Developer & Programmer » JDeveloper, Java & XML » OA Page Error (10.1.3)
OA Page Error [message #340646] Wed, 13 August 2008 10:42 Go to next message
satya.das2007
Messages: 33
Registered: February 2007
Location: India
Member
I am trying to create a simple page with insert,update and delete functionality. while doing deletion steps I am getting following error.
"JBO-26080: Error while selecting entity for XxbgSfFlipIdEO" ,while checking below the exact error show :

"java.sql.SQLException: ORA-00911: invalid character".
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Also at the time of insert new record I am getting the following error:

JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO XXBG.XXBG_SF_FLIP_ID(OLD_PERSON_ID,NEW_PERSON_ID,EMPLOYEE_NAME,USER_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_ DATE,CREATED_BY,ENABLE_FLAG) VALUES (?,?,?,?,?,?,?,?,?,?) RETURNING OLD_PERSON_ID, NEW_PERSON_ID, EMPLOYEE_NAME, USER_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, ENABLE_FLAG INTO ?, ?, ?, ?, ?, ?, ?, ?, ?, ?; END;".

--------------------------------------------------

java.sql.SQLException: ORA-06550: line 1, column 189: PL/SQL: ORA-00911: invalid character ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored


I am not able to identify how this error is coming? This looks to be a database error but dont know why it is coming up in OA page. Can anyone please suggest?

Regards,
Satya
Re: OA Page Error [message #340648 is a reply to message #340646] Wed, 13 August 2008 10:46 Go to previous messageGo to next message
satya.das2007
Messages: 33
Registered: February 2007
Location: India
Member
On further Investigation I could find the following details:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
08/08/13 10:43:47 [790] New Language Code = null
08/08/13 10:43:47 [791] Current Language Code = US
08/08/13 10:43:47 [792] In OADBTransactionImpl.commit()
08/08/13 10:43:47 [793] OracleSQLBuilder: SAVEPOINT 'BO_SP'
08/08/13 10:43:47 [794] OracleSQLBuilder Executing, Lock 2 DML on: XXBG.XXBG_SF_FLIP_ID (Insert)
08/08/13 10:43:47 [795] INSERT buf XxbgSfFlipIdEO>#i SQLStmtBufLen: 1020, actual=396
08/08/13 10:43:47 [796] BEGIN INSERT INTO XXBG.XXBG_SF_FLIP_ID(OLD_PERSON_ID,NEW_PERSON_ID,EMPLOYEE_NAME,USER_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_ DATE,CREATED_BY,ENABLE_FLAG) VALUES (?,?,?,?,?,?,?,?,?,?) RETURNING OLD_PERSON_ID, NEW_PERSON_ID, EMPLOYEE_NAME, USER_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, ENABLE_FLAG INTO ?, ?, ?, ?, ?, ?, ?, ?, ?, ?; END;
08/08/13 10:43:47 [797] Insert binding param 1: 435334
08/08/13 10:43:47 [798] Insert binding param 2: 435435
08/08/13 10:43:47 [799] Insert binding param 3: satua
08/08/13 10:43:47 [800] Insert binding param 4: sdas
08/08/13 10:43:47 [801] Insert binding param 5: 2008-08-13 08:40:46.0
08/08/13 10:43:47 [802] Insert binding param 6: 13298
08/08/13 10:43:47 [803] Insert binding param 7: 5416784
08/08/13 10:43:47 [804] Insert binding param 8: 2008-08-13 08:40:46.0
08/08/13 10:43:47 [805] Insert binding param 9: 13298
08/08/13 10:43:47 [806] Insert binding param 10: Y
08/08/13 10:43:48 [807] OracleSQLBuilderImpl.doEntityDML failed...
08/08/13 10:43:48 [808] X/Open SQL State is: 65000
08/08/13 10:43:48 [809] java.sql.SQLException: ORA-06550: line 1, column 189:
PL/SQL: ORA-00911: invalid character
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignored

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The custom table is having only one primary key constraint (OLD_PERSON_ID) and table structure is:

Name Type Nullable
----------------- ------------- -------- ------- --------
OLD_PERSON_ID VARCHAR2(100)
NEW_PERSON_ID VARCHAR2(100) Y
EMPLOYEE_NAME VARCHAR2(500) Y
USER_NAME VARCHAR2(100) Y
LAST_UPDATE_DATE DATE Y
LAST_UPDATED_BY NUMBER Y
LAST_UPDATE_LOGIN NUMBER Y
CREATION_DATE DATE Y
CREATED_BY NUMBER Y
ENABLE_FLAG VARCHAR2(10) Y
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Please anyone review and suggest.

Regards,
Satya
Re: OA Page Error [message #340869 is a reply to message #340646] Thu, 14 August 2008 13:07 Go to previous message
satya.das2007
Messages: 33
Registered: February 2007
Location: India
Member
I think the insert command is failing with date format issue. The jdeveloper is firing the following statement:

BEGIN
INSERT INTO xxbg.xxbg_sf_flip_id
(old_person_id
,new_person_id
,employee_name
,user_name
,last_update_date
,last_updated_by
,last_update_login
,creation_date
,created_by
,enable_flag)
VALUES
(435334
,435435
,'satua'
,'sdas'
,'2008-08-13 08:40:46.0'
,'13298'
,'5416784'
,'2008-08-13 08:40:46.0'
,13298
,'Y');
END;

Now How can I change the date format in Jdeveloper. This is auto generated insert script, so how to change this format so that it will allow me to insert record?

Is there any property in Jdeveloper I need to set for date item?

Please suggest...

Regards,
Satya
Previous Topic: XML Document Formatting
Next Topic: java stored procedure
Goto Forum:
  


Current Time: Thu Mar 28 07:35:26 CDT 2024