My Oracle Support Banner

ORA-00600 [736] from PL/SQL for Insert Statement (Doc ID 2539213.1)

Last updated on NOVEMBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

An INSERT statement executed from PL/SQL fails with the following error:

In the failing statement the same bind variable name is used more than once and a table with XMLTYPE column(s) is involved.

Eg:
----- Current SQL Statement for this session (sql_id=<sql_id>) -----
INSERT INTO <TABLE_NAME1> (<COL1>,<COL2><COL3>,..<COLn>) (SELECT <COL1>....<COLn> from <TABLE_NAME2> WHERE <COL1>=:B1 AND <COL2> NOT IN (SELECT <COL2> FROM <TABLE_XML>)
UNION ALL
SELECT <COL1>....<COLn> from <TABLE_NAME2> WHERE <COL1>=:B1 AND <COL2> NOT IN (SELECT <COL2> FROM <TABLE_XML>))
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object line object
  handle number name
c000000451e10980 388 package body <OWNER>.<PACKAGE_NAME>
d0000003f73f60c0 4 anonymous block

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.