Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

update portal.WWDOC_DOCUMENT$ fields manually

703660Feb 22 2010
hi all I want to update portal.WWDOC_DOCUMENT$ fields manually. Specifically the fields blob_content and last_update.
When i update the blob_content it is ok.

When i execute update

update portal.wwdoc_document$ set last_updated=sysdate where filename like '2%.xml' i get error


java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1810

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1644
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "PORTAL.WWCTX_SSO", line 1973
ORA-06512: at "PORTAL.WWCTX_API", line 279
ORA-06512: at "PORTAL.WWERR_API_ERROR", line 99
ORA-06512: at "PORTAL.WWERR_API_ERROR", line 222
ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 63
ORA-06512: at "PORTAL.WWV_THINGDB", line 1446
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1810
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1644
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "PORTAL.WWCTX_SSO", line 1973
ORA-06512: at "PORTAL.WWCTX_API", line 279
ORA-06512: at "PORTAL.WWERR_API_ERROR", line 147
ORA-06512: at "PORTAL.WWERR_API_ERROR", line 305
ORA-06512: at "PORTAL.WWSBR_STDERR", line 27
ORA-06512: at "PORTAL.WWSBR_SITE_DB", line 2270

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at "PORTAL.WWCTX_SSO", line 1810

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at "PORTAL.WWCTX_SSO", line 1644

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "PORTAL.WWDOC_DOCU_BRU_TRG", line 112

ORA-04088: error during execution of trigger 'PORTAL.WWDOC_DOCU_BRU_TRG'


What should i do? I call the update from a java servlet.
The blob_update works fine. the last_update doesn't work

Thanks in advance from your help

Regards,

Antonis
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2010
Added on Feb 22 2010
0 comments
263 views