ora-06512
ORA-01438 Error
Can anyone help me with this exception? ORA-01438: value larger than specified precision allowed for this column[详细]
2023-03-28 06:45 分类:问答pl sql exception message
I have following error message. 2011-08-08 14:27:09 [E]: xxx - ORA-06502: PL/SQL: numeric or value error:[详细]
2023-03-27 17:18 分类:问答How to use a stored procedure to read a file into an oracle DB
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:[详细]
2023-03-20 00:53 分类:问答Oracle error log file
I\'m running following block in Oracle (what does it do is not so important) BEGIN 开发者_如何学PythonSDO_RDF_INFERENCE.CREATE_RULES_INDEX([详细]
2023-03-18 22:45 分类:问答RAISE_APPLICATION_ERROR issue
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[详细]
2023-03-14 09:08 分类:问答Invalid privilege error?
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[详细]
2023-03-10 01:58 分类:问答ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536
Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name VARCHAR2(50);[详细]
2023-03-06 16:24 分类:问答error reading xml from the plsql procedure
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[详细]
2023-03-01 07:14 分类:问答CREATE Oracle Procedure
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[详细]
2023-02-01 15:47 分类:问答Oracle's dbms_metadata.get_ddl for object_type JOB
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:[详细]
2023-01-07 14:27 分类:问答