Oracle Help
in [SQL]
|
java.sql.SQLException: Data size bigger than max size for this type: 3991 Hi, i have been using setString() of prepared statement. but it is giving me java.sql.SQLException: Data size bigger than max size for this type: 3991 exception. where as as per my understanding, the size of varchar2 is 4000. can someone suggest the solution thanks in advance. ... 24 Jul 2008 05:42
NLS_LANG I'm setting up Oracle libraries in a Windows Server box so two PHP web sites can access a remote Oracle 10g database. I've downloaded the Instant Client *.zip package and everything works fine so far, except for some charset issues (Spanish letters do not show properly). Setting NLS_LANG environmental variable ... 25 Jul 2008 14:32
Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE Hello, I have a (application-)database which is filled with polygons, also there is a administrative coupling on a guid. The guid is unique for the administative part, but can contain more than 1 polygon. For this reason i want to union the polygons, so i have 1 geometry for 1 guid. Well, i managed to do this tr... 19 Jun 2008 01:14
oracle 9i: errors by clone a DB by a script Hi, I have to clone a DB to built a Test DB. To avoid manual work our admin wrote a script, that in general - fills some files with file structure - fills some files with parameters - shuts down the database - copies and packs all datafiles - startd the database and back: - fills the filestructure from fil... 21 Apr 2008 17:21
10g ORA-30625: method dispatch on NULL SELF argument is disallowed On May 23, 9:15 am, stephen O'D <stephen.odonn...(a)gmail.com> wrote: RETURN p_response.doc.extract('//'||p_name||'/ child::text()',p_namespace).getstringval(); Thank you. l_reponse is not null. Sorry new to Oracle and XML, how do I convert (or cast) a type .doc to string so you can display it? I want to di... 23 May 2007 12:13
to_char(date) gives the result 00-000-00 first row was inserted using the sql insert. remaining rows are inserted from the c++ engine When i do to_char of the date y it give me 00-000-00 SQL> select to_char(y),y from x; TO_CHAR(Y) Y --------------- --------- 23-MAR-07 23-MAR-07 00-000-00 01-JUN-01 00-000-00 ... 26 Mar 2007 12:21
some errors when using impdp I use expdp to export a database from Oracle XE to a dump file and use impdp to import it to Oracle 10g2. The import looks ok, and data looks good but the import process shows some errors that I am not sure if it will cause any problem later. One of the errors is : ORA-39083: Object type INDEX_STATISTICS failed t... 28 Feb 2007 16:54
ORA-01858 The following SQL works well without the last line, once I add the last line, I get ORA-01858. I am not sure why it works in the SELECT but not in the WHERE clause. We have Oracle 9.2.0.7. select msg, source, msg_type, svr_cd, to_date(substr(msg,instr(msg,'Eff Dt:') + 8,10), 'mm/dd/yyyy') from hotlist wh... 28 Feb 2007 18:37
Trouble with UTL_DBWS / SOAPACTION_URI Hi all, I'm trying to create some code which consumes a web service through the use of UTL_DBWS, but I keep getting this error: ORA-29532: Java call terminated by uncaught Java exception: javax.xml.rpc.soap.SOAPFaultException: ARERR [9331] No operation named Envelope exists in web service AST_CDROMDrive. Ap... 9 Feb 2007 15:08
Using UTL_DBWS to access a web service Hi, I am attempting to use UTL_DBWS in order to access a web service: CREATE OR REPLACE FUNCTION update_status RETURN VARCHAR2 AS l_service sys.UTL_DBWS.service; l_call sys.UTL_DBWS.call; l_result SYS.XMLTYPE; l_wsdl_url VARCHAR2(1024); l_service_name VARCHAR2(200); l_oper... 7 Feb 2007 14:04 |