Welcome! This is a website that everyone can build together. It's easy!

Location: PL/SQL

Discussion: PL/SQL Webservices

Keyword tags: PL/SQL PL/SQL Intro

Watch

Anonymous  (Get credit for your thread)
wikiponic

wikiponic		 PL/SQL Webservices
Jan 22 2008, 3:27 AM EST
Hello,

I created a procedure which contains couple of htp.prn statements which I used to output my content.
However when I create my webservice out of those procedures I get errors.
Anybody tried this before, kindly provide your thoughts and inputs.

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
 0  out of 9 found this valuable. Do you?    
pvzweden

pvzweden		 RE: PL/SQL Webservices
Jan 24 2008, 4:31 AM EST
With one of the calls, does the data by accident only contain numbers? Because oracle then might the prn function which uses a number as data in.
You then would just have a normal problem of data containing a dot when oracle expects a comma or the other way arround.

You could also try to open the package source of the sys htp package and look what happens at lin 1689
 2  out of 6 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Advantage with Oracle PL/SQL, Pro*C Process code generation interface Base64 Encoding/Decoding from PL/SQL PL/SQL DES3 Encryption/Decryption
Cheap Apex Hosting PL/SQL Application Express
PL/SQL Best Practices Middleware Certification Designing PL/SQL apps