Stack Overflow
Stack Overflow

Questions tagged [ora-06512]

Oracle database error code ORA-06512: unhandled exception

Error:

ORA-06512 is an error indicating the line number at which a PL/SQL error occurred if the previous exception was unhandled.

Cause:

If an exception was not handled, Oracle will display the unhandled exception with the specific error code and display the approximate line number at which the error occurred. The line number is shown in the error stack with the error code: ORA-06512.

Solution:

Analyse & rectify the actual cause of error. Since this error is informational, tackling the actual exception will clear this exception as well.

References:

44 questions
15
votes
6 answers

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); file_handle utl_file.file_type; BEGIN file_name := 'table.txt'; file_handle :=…
Vivek
  • 4,452
  • 10
  • 27
  • 45
12
votes
3 answers

Oracle Error ORA-06512

Just can't figure out why it gives me ORA-06512 Error PROCEDURE PX(pNum INT,pIdM INT,pCv VARCHAR2,pSup FLOAT) AS vSOME_EX EXCEPTION; BEGIN IF ((pNum < 12) OR (pNum > 14)) THEN RAISE vSOME_EX; ELSE EXECUTE…
Tililin Tin Tin
  • 151
  • 1
  • 1
  • 7
6
votes
6 answers

Validating XML files against schema in Oracle PL/SQL

I have a requirement to validate an incoming file against an XSD. Both will be on the server file system. I've looked at dbms_xmlschema, but have had issues getting it to work. Could it be easier to do it with some Java?What's the simplest class I…
steevc
  • 662
  • 2
  • 10
  • 19
6
votes
4 answers

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: select dbms_metadata.get_ddl ( 'VIEW', 'SAMPLE_VIEW') from dual On the…
asalamon74
  • 6,120
  • 9
  • 46
  • 60
6
votes
3 answers

PL/SQL Append_Values Hint gives error message

I am having trouble doing a large number of inserts into an Oracle table using PL/SQL. My query goes row-by-row and for each row the query makes a calculation to determine the number of rows it needs to insert into the another table. The…
user3312037
  • 61
  • 1
  • 1
  • 2
4
votes
4 answers

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 SQL> begin 2 Update_STUD_Fin ( '1011'); 3 end; 4 / begin * ERROR at line 1: ORA-06511: PL/SQL:…
mohammad
  • 41
  • 1
  • 2
3
votes
3 answers

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: create or replace PROCEDURE upload_supp_data IS src_file BFILE; dst_file …
Lazloman
  • 1,289
  • 5
  • 25
  • 50
3
votes
3 answers

Oracle error log file

I'm running following block in Oracle (what does it do is not so important) BEGIN SDO_RDF_INFERENCE.CREATE_RULES_INDEX( 'my_index', SDO_RDF_Models('my_model'), SDO_RDF_Rulebases('RDFS')); END; and getting following error: ORA-29532:…
Yury Litvinov
  • 1,354
  • 2
  • 16
  • 24
3
votes
3 answers

DBMS_Snapshot.refresh not working on 11g , materialized view error

I executed DBMS_Snapshot.refresh on Oracle 10g it worked fine, but when i execute the same on Oracle 11g it gives the following error DBMS_SNAPSHOT.refresh('Table1','F'); BEGIN DBMS_SNAPSHOT.refresh('Table1','F'); END; . * ERROR at line 1:…
Nandish A
  • 1,645
  • 5
  • 26
  • 41
3
votes
3 answers

Oracle 00932. 00000 - "inconsistent datatypes: expected %s got %s"

well i'm still new in oracle, i'm trying to query a table with a subquery..it looks like this select id_user, count(*) as jumlah from (select * from users where username = 'usr' and pass = 'pwd' and company_id = 'PAN' and status = 1) group by…
thekucays
  • 568
  • 3
  • 9
  • 32
2
votes
1 answer

ORA-12545: Connect failed because target host or object does not exist ORA-06512

I have the following error message when I try to establish a HTTP request connection: ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1029 ORA-12545: Connect failed because target host or object does not exist ORA-06512: at line…
Shaban Mousa
  • 154
  • 1
  • 2
  • 8
2
votes
1 answer

run string as query in oracle

i got a little problem in Oracle. I try to create a sequence for generating IDs in a table that already has data in it. I try to use the following anonymous block. declare y varchar2(2000); BEGIN SELECT 'CREATE SEQUENCE ID_SEQ MINVALUE 1 MAXVALUE…
mitereiter
  • 35
  • 1
  • 4
1
vote
2 answers

SYSDATE - 1 error on pl/sql function

I have an issue: when i issue this function below ti gives me the following error: select 'EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'''||name||'''||,OPTIONS=>DBMS_LOGMNR.NEW);' from v\$archived_log where name is not null; select 'EXECUTE…
ayo
1
vote
1 answer

No result from a query stored in a VARCHAR2 variable is treated as an empty string or a NULL? - Oracle PL/SQL - Oracle 11g

I have a procedure which performs a SELECT INTO and stores the returned result in a VARCHAR2 variable called account_: SELECT DISTINCT NVL(XYZ_API.Get_Ref(company, currency, pay_type, order_id), XYZ_API.Get_Id(company, currency,…
Uthpala Dl
  • 45
  • 8
1
vote
2 answers

Oracle: Inconsistent Datatype Issue

I am getting inconsistent datatype error message and I am not sure why. I need some guidance to figure this out. I am creating two types as: My universe table have following columns with column type: Column Name Data…
Rachel
  • 100,387
  • 116
  • 269
  • 365
1
2 3