Can anyone help me with this exception? ORA-01438: value larger than specified precision allowed for this column
I have following error message. 2011-08-08 14:27:09 [E]: xxx - ORA-06502: PL/SQL: numeric or value error:
I\'m trying to read a file into my oracle table as a blob. The file is *.gz data. I looked around the \'net and found some examples, and this is what I\'ve come up with:
I\'m running following block in Oracle (what does it do is not so important) BEGIN 开发者_如何学PythonSDO_RDF_INFERENCE.CREATE_RULES_INDEX(
I have developed a trigger that checks the validity of a date. It works fine because it prevents me from storing an invalid date, but I also get a weird error message and I can\'t figure out why. My c
Two related applications use a function in a package in several queries to return some data as CSV. The column being selected and concatenated is a CLOB field and can cont开发者_C百科ain HTML, special
Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name VARCHAR2(50);
I am trying to read a xml from plsql procedure using the xmlparser package, i am getting this error ORA-31020: The operation is not 开发者_如何学JAVAallowed, Reason: Not supported
I am trying to create a procedure and it created without error. However when I try to run it then I will get following error. Please advise
I\'d like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of the object types. For instance the following creates the ddl for a view: