Skip to Main Content
Forums

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!

htp packages giving error when being called from web service

422368Dec 13 2007 — edited Jan 22 2008
Hello

I create a procedure in portal and to display the output I am using htp.


When I run the procedure in a browser it works fine. However when I create a webservice from the procedure and when I call the webservice, I get the errors pasted below.

If I remove the htp line from the procedure and then call the web service, it doesn't throw any error.

Any help is highly appreciable.

Thanks

Internal Server Error (Caught exception while handling request: java.rmi.RemoteException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 328
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2008
Added on Dec 13 2007
28 comments
2,482 views